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.
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
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 ( anycompatiblearray, anycompatible [, integer ] ) → integer → integerReturns 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.Full definition and evidence JSON
center · PostgreSQL 18 · wiki-repair-20261023:ddd930de8ef35e8abcfd468bedf6808d5ffcf15fc63b3aba74613119fea4857a
Text language: en · wiki-repair-20261023:ddd930de8ef35e8abcfd468bedf6808d5ffcf15fc63b3aba74613119fea4857a