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

> adrian.klaver@aklaver.com wrote:
>
> bryn@yugabyte.com 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'llconcede, with the benefit of hindsight, that I should have thought of that.) I hope that I'll be able to learn to
navigatethe 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
functionsor the index and I knew they where not relevant. 

I just repeated exactly those five search steps. I copied the first ten results at the end. Yes, the fifth hit is the
linkto where the account of the array() constructor is found. But you can't tell this from the hitlist itself. And
searchingin the page of the first twenty hits for "array(" finds nothing there. I do see that if you know the answer in
advance,then you could realize that hit #5 is what you want. But the wording "a specific element of the array value can
beextracted" didn't help me. 

Never mind, I trust that I'll remember where to look now.

--------------------------------------------------------------------------------

Result pages: 1 2 3 4 5 6 7 8 9 Next

1. PostgreSQL: Documentation: 14: 8.15. Arrays [8.21]
...Arrays Prev Up Chapter 8. Data Types Home Next 8.15. Arrays 8.15.1. Declaration of Array...
https://www.postgresql.org/docs/14/arrays.html

2. PostgreSQL: Documentation: 14: 9.19. Array Functions and Operators [5.04]
...Array Functions and Operators Prev Up Chapter 9. Functions and Operators Home Next 9.19. Array...
https://www.postgresql.org/docs/14/functions-array.html

3. PostgreSQL: Documentation: 14: 9.16. JSON Functions and Operators [4.25]
...array (array elements are indexed from zero, but negative integers count from the end).
'[{"a":"foo"},{"b":"bar"},{"c":"baz"}]'::json...
https://www.postgresql.org/docs/14/functions-json.html

4. PostgreSQL: Documentation: 14: Index [2.63]
...array, Arrays accessing, Accessing Arrays constant, Array Value Input constructor, Array Constructors declaration,
Declarationof Array... 
https://www.postgresql.org/docs/14/bookindex.html

5. PostgreSQL: Documentation: 14: 4.2. Value Expressions [2.27]
...array type, then a specific element of the array value can be extracted by writing...
https://www.postgresql.org/docs/14/sql-expressions.html

6. PostgreSQL: Documentation: 14: 8.14. JSON Types [1.76]
...array on the right side is not considered contained within the -- array on the left...
https://www.postgresql.org/docs/14/datatype-json.html

7. PostgreSQL: Documentation: 14: 66.3. Extensibility [1.33]
...array of operators and comparison values */ ScanKey orderbys; /* array of ordering operators and comparison *
values...
https://www.postgresql.org/docs/14/spgist-extensibility.html

8. PostgreSQL: Documentation: 14: F.18. intarray [1.33]
...arrays. Although they will accept input arrays of more dimensions, the data is treated as though...
https://www.postgresql.org/docs/14/intarray.html

9. PostgreSQL: Documentation: 14: CREATE TYPE [1.33]
...array type; for example, it will not be a candidate for the result type of ARRAY...
https://www.postgresql.org/docs/14/sql-createtype.html

10. PostgreSQL: Documentation: 14: 9.24. Row and Array Comparisons [1.15]
...Array Comparisons Prev Up Chapter 9. Functions and Operators Home Next 9.24. Row and Array...
https://www.postgresql.org/docs/14/functions-comparisons.html