Returns an array of the subscripts of all occurrences of the second argument in the array given as first argument. The array must be one-dimensional. Comparisons are done using IS NOT DISTINCT FROM semantics, so it is possible to search for NULL. NULL is returned only if the array is NULL; if the value is not found in the array, an empty array is returned.
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
IS NOT DISTINCT FROM semantics, so it is possible to search for NULL. NULL is returned only if the array is NULL; if the value is not found in the array, an empty array is returned.array_positions ( anycompatiblearray, anycompatible ) → integer[] → integer[]Returns an array of the subscripts of all occurrences of the second argument in the array given as first argument. The array must be one-dimensional. Comparisons are done using
IS NOT DISTINCT FROM semantics, so it is possible to search for NULL. NULL is returned only if the array is NULL; if the value is not found in the array, an empty array is returned.Full definition and evidence JSON
center · PostgreSQL 18 · wiki-repair-20261023:7ca26ccd52fff627c64bd3a82b8395b40a99aa5d4e27b65419cb29ab0c478438
Text language: en · wiki-repair-20261023:7ca26ccd52fff627c64bd3a82b8395b40a99aa5d4e27b65419cb29ab0c478438