SUBSTRB
Returns an octet value representing the substring of a specified string.
Behavior Type
Syntax
SUBSTRB ( string , position [ , extent ] )
Parameters
string |
(CHAR/VARCHAR) is the string from which to extract a substring. |
position |
(INTEGER or DOUBLE PRECISION) is the starting position of the substring (counting from one in octets). |
extent |
(INTEGER or DOUBLE PRECISION) is the length of the substring to extract (in octets). The default is the end of the string |
Notes
- This function treats the multibyte character string as a string of octets (bytes) and uses octet numbers as incoming and outgoing position specifiers and lengths. The strings themselves are type VARCHAR, but they treated as if each octet were a separate character.
- SUBSTRB truncates DOUBLE PRECISION input values.
Examples
=> SELECT SUBSTRB('soupçon', 5); SUBSTRB --------- çon (1 row)
=> SELECT SUBSTRB('soupçon', 5, 2); SUBSTRB --------- ç (1 row)
Vertica returns the following error message if you use BINARY/VARBINARY:
=>SELECT SUBSTRB('abc'::binary(3),1); ERROR: function substrb(binary, int) does not exist, or permission is denied for substrb(binary, int) HINT: No function matches the given name and argument types. You may need to add explicit type casts.