> adrian.kla...@aklaver.com wrote:
>
> b...@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'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.
I just repeated exactly those five search steps. I copied the first ten results
at the end. Yes, the fifth hit is the link to where the account of the array()
constructor is found. But you can't tell this from the hitlist itself. And
searching in 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 be extracted" 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, Declaration of 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
