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
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.
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных