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

On Sunday, September 18, 2022, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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:

https://www.postgresql.org/docs/current/bookindex.html#indexdiv-A

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

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

David J.