On Mon, 12 Jul 2021 at 11:52, David G. Johnston <david.g.johns...@gmail.com> wrote: > A post over in Reddit had an expression form I've never seen before: > > select (array[1,2,3,4]::integer[])[generate_series(1, 3)];
> Looking at subscripting in the SQL syntax this example doesn't seem to be > documented. > > https://www.postgresql.org/docs/current/sql-expressions.html#SQL-EXPRESSIONS-SUBSCRIPTS > > Is it documented somewhere else, and, regardless, shouldn't it be documented > in the linked location? Isn't this implied by "Each subscript is itself an expression"? There's nothing special here with the SRF. That just produces 3 rows and passes the subscript as 1, 2 then 3. David
