Functions / Set Returning Functions

generate_subscripts

Generates a series comprising the valid subscripts of the dim'th dimension of the given array.

Reading PG 18current·documented in 19 of 27 versions, 8.4 to 20

7.1 7.2 7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Signatures & examples

generate_subscripts ( array anyarray, dim integer ) → setof integer

Generates a series comprising the valid subscripts of the dim'th dimension of the given array.

generate_subscripts ( array anyarray, dim integer, reverse boolean ) → setof integer

Generates 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.

Version history 2

12 → 13 changed
8.3 → 8.4 added

Definition snapshot: b7bd9cda · English manual source