On Sunday, September 18, 2022, Adrian Klaver <adrian.kla...@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: 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.
