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

From Adrian Klaver
Subject Re: Where's the doc for "array()" — as in "select array(values (17), (42))"
Date
Msg-id e6ac86e5-39f4-9704-7260-3f6c40c63b2d@aklaver.com
Whole thread Raw
In response to Where's the doc for "array()" — as in "select array(values (17), (42))"  (Bryn Llewellyn <bryn@yugabyte.com>)
Responses Re: Where's the doc for "array()" — as in "select array(values (17), (42))"
Re: Where's the doc for "array()" — as in "select array(values (17), (42))"
List pgsql-general
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@aklaver.com



pgsql-general by date:

Previous
From: Bryn Llewellyn
Date:
Subject: Where's the doc for "array()" — as in "select array(values (17), (42))"
Next
From: Adrian Klaver
Date:
Subject: Re: Where's the doc for "array()" — as in "select array(values (17), (42))"