|
|
|
|
|
|
This section describes functions and operators for examining and manipulating string values. Strings in this context include values of all the types CHARACTER and CHARACTER VARYING. Unless otherwise noted, all of the functions listed below work on all of these types, but be wary of potential effects of the automatic padding when using the CHARACTER type. Generally, the functions described here also work on data of non-string types by converting that data to a string representation first. Some functions also exist natively for the bit-string types.
The string functions not handle multibyte UTF-8 sequences correctly. They treat each byte as a character.