POSITIONB
Returns an INTEGER value representing the octet location of a specified substring with a string (counting from one).
Behavior Type
Syntax
POSITIONB ( string, substring )
Parameters
string |
(CHAR or VARCHAR) is the string in which to locate the substring |
substring |
(CHAR or VARCHAR) is the substring to locate |
Examples
=> SELECT POSITIONB('straße', 'ße'); POSITIONB ----------- 5 (1 row)
=> SELECT POSITIONB('étudiant', 'é'); POSITIONB ----------- 1 (1 row)