Re: Where's the doc for "array()" — as in "select array(values (17), (42))"

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Where's the doc for "array()" — as in "select array(values (17), (42))"
Дата
Msg-id CAKFQuwb5tr4r4xjooXXwuuC+orJusgGxd4=uGs9SHhGNywzPLw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Where's the doc for "array()" — as in "select array(values (17), (42))"  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Дерево обсуждения
On Sunday, September 18, 2022, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 9/18/22 13:25, Bryn Llewellyn wrote:
I noticed that "array()" is used in the query that implements the "\du" psql meta-command. It has some similarity with "array_agg()" thus:

create temporary view x(v) as (values (17), (42));
select array_agg(v) from x;
select array(select v from x);


Anyway, I can't find where "array()" is documented. Google does find me a hit on stackexchange.com <http://stackexchange.com>. But it doesn't x-ref to the PG doc.

https://www.postgresql.org/docs/current/sql-expressions.html

Which on can find fairly directly via the index entry for array:


Or browsing the syntax chapter via the table of contents (everything is either a function or syntax, and you ruled out the former).


David J.

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Where's the doc for "array()" — as in "select array(values (17), (42))"
Следующее
От: Bryn Llewellyn
Дата:
Сообщение: Re: Where's the doc for "array()" — as in "select array(values (17), (42))"