Premium
Log in
PostgreSQL Function Reference
POSITION
Returns the starting position of a substring in the string, or zero if not found.
PostgreSQL 17.5
POSITION(substring IN string)substring
The substring to search for.
IN string
The source string.
Examples
PostgreSQL 17.5
SELECT POSITION('om' IN 'Thomas')