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

On 9/18/22 21:20, Bryn Llewellyn wrote:

>
> Thanks. I can't, even now, formulate a search that finds this—unless I
> know that it's a kind of array constructor. (I'll concede, with the
> benefit of hindsight, that I should have thought of that.) I hope that
> I'll be able to learn to navigate the PG docs better over time.

The way I found it:

1) Use documentation search box.

2) Enter array(

3) It was in the fifth item PostgreSQL: Documentation: 14: 4.2. Value
Expressions. The first four dealt with functions or the index and I knew
they where not relevant.

>
> Why is the "array()" constructor not found in "pg_proc"? After all,
> section 4.2.12 refers to "array_agg()" as a constructor. And that *is*
> found in "pg_proc".

The only place I see array_agg in 4.2.x is 4.2.7. Aggregate Expressions.

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com