postgres：使用子查询设置数组的值？

发布于 2024-10-15 06:32:39 字数 308 浏览 2 评论 0原文

在postgres中，可以将INSERT中的数组值设置为子查询的结果吗？例如：

INSERT INTO mytable
VALUES( SELECT list_of_integers FROM someothertable WHERE somekey = somevalue);

mytable 只有一列是 integer[] 类型，而另一列 list_of_integers 也是 integer 类型[]？

原文

In postgres, can you set the value of an array in an INSERT to the result of a subquery? Like:

INSERT INTO mytable
VALUES( SELECT list_of_integers FROM someothertable WHERE somekey = somevalue);

Where that mytable just has as its one column a type of integer[] and that other column list_of_integers is also type integer[] ?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

帥小哥 2024-10-22 06:32:39

您需要 unnest 函数。我想你会这样使用它：

INSERT INTO mytable
SELECT set_of_integers
FROM unnest(
  SELECT list_of_integers
  FROM someothertable
  WHERE somekey = somevalue
) t(set_of_integers)

但是我没有 PostgreSQL 可以自己尝试一下。

You want the unnest function. I think you'd use it like:

INSERT INTO mytable
SELECT set_of_integers
FROM unnest(
  SELECT list_of_integers
  FROM someothertable
  WHERE somekey = somevalue
) t(set_of_integers)

But i don't have PostgreSQL to hand to try it out myself.

回复收藏 0 原文

嗳卜坏 2024-10-22 06:32:39

是的：

INSERT INTO
     mytable
    (column1, column2, an_array_of_integers_column)
VALUES
    (2, 'bbb', (SELECT list_of_integers FROM someothertable WHERE somekey = somevalue));

Yes:

INSERT INTO
     mytable
    (column1, column2, an_array_of_integers_column)
VALUES
    (2, 'bbb', (SELECT list_of_integers FROM someothertable WHERE somekey = somevalue));

回复收藏 0 原文

~没有更多了~