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
4.2.12. Array Constructors
"It is also possible to construct an array from the results of a
subquery. In this form, the array constructor is written with the key
word ARRAY followed by a parenthesized (not bracketed) subquery. For
example:
SELECT ARRAY(SELECT oid FROM pg_proc WHERE proname LIKE 'bytea%');
..."
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx