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.klaver@aklaver.com