STRPOSB
Returns an INTEGER value representing the location of a specified substring within a string, counting from one, where each octet in the string is counted (as opposed to characters).
Behavior Type
Syntax
STRPOSB ( 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 |
Notes
STRPOSB is identical to POSITIONB except for the order of the arguments.
Examples
=> SELECT STRPOSB('straße', 'e'); STRPOSB --------- 7 (1 row)
=> SELECT STRPOSB('étudiant', 'tud'); STRPOSB --------- 3 (1 row)