Functions / Array Functions And Operators

array_position

Returns the subscript of the first occurrence of the second argument in the array, or NULL if it's not present.

Reading PG 18current·documented in 13 of 27 versions, 9.5 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

array_position ( anycompatiblearray, anycompatible [, integer ] ) → integer

Returns the subscript of the first occurrence of the second argument in the array, or NULL if it's not present. If the third argument is given, the search begins at that subscript. The array must be one-dimensional. Comparisons are done using IS NOT DISTINCT FROM semantics, so it is possible to search for NULL.

array_position(ARRAY['sun', 'mon', 'tue', 'wed', 'thu', 'fri', 'sat'], 'mon') → 2

Version history 3

13 → 14 changed
12 → 13 changed
9.4 → 9.5 added

Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source