generate_subscripts ( array anyarray, dim integer ) → setof integer → setof integerGenerates a series comprising the valid subscripts of the
dim'th dimension of the given array.generate_subscripts
Generates a series comprising the valid subscripts of the dim'th dimension of the given array.
English manual coverage begins with PostgreSQL 7.1. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- group
- srf
- group label
- Set Returning Functions
- lang
- en
- layout
- table-new
- pages
- functions-srf.html
- prose only
- false
Definition PG 18
Generates a series comprising the valid subscripts of the
dim'th dimension of the given array.Signatures and overloads
generate_subscripts ( array anyarray, dim integer, reverse boolean ) → setof integer → setof integerGenerates a series comprising the valid subscripts of the
dim'th dimension of the given array. When reverse is true, returns the series in reverse order.Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · wiki-repair-20261023:cb05a6e4354d67e1ce63f83f9233fa8ac6eca1e62498a92ea82e8ad6da8aaf65
Text language: en · wiki-repair-20261023:cb05a6e4354d67e1ce63f83f9233fa8ac6eca1e62498a92ea82e8ad6da8aaf65