Mega Code Archive

 

Categories / PostgreSQL / String Functions

 

Position(substring in string) int Location of specified substring

postgres=# postgres=# -- position(substring in string) int Location of specified substring postgres=# postgres=# select position('\\000om'::bytea in 'Th\\000omas'::bytea);  position ----------         3 (1 row) postgres=# postgres=#