position ( substring text IN string text ) → integerReturns first starting index of the specified
substring within string, or zero if it's not present.position('om' in 'Thomas') → 3FUNCTIONS / STRING FUNCTIONS AND OPERATORS
position
Read PG 18 manual ↗Returns first starting index of the specified substring within string, or zero if it's not present.
Signatures & examples
position ( substring bytea IN bytes bytea ) → integerReturns first starting index of the specified
substring within bytes, or zero if it's not present.position('\x5678'::bytea in '\x1234567890'::bytea) → 3position ( substring bit IN bits bit ) → integerReturns first starting index of the specified
substring within bits, or zero if it's not present.position(B'010' in B'000001101011') → 8
Version history 1
- PG 12 → 13changed
Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source