Functions / String Functions And Operators

strpos

Returns first starting index of the specified substring within string, or zero if it's not present.

Reading PG 18current·documented in 27 of 27 versions, 7.1 to 20

7.1 7.2 7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Signatures & examples

strpos ( string text, substring text ) → integer

Returns first starting index of the specified substring within string, or zero if it's not present. (Same as position(substring in string), but note the reversed argument order.)

strpos('high', 'ig') → 2

Version history 3

12 → 13 changed
7.3 → 7.4 changed
7.2 → 7.3 changed

Definition snapshot: b7bd9cda · English manual source