String Operators
Essentially, all string operators return implicit Boolean true or false values given the supplied comparison. (The exception is the concatenation operators shown in the next “Listing” section.)
When making comparisons, the characters’ location in the ANSI chart is taken into account. Therefore, a lowercase “a” is seen as less than (<) an uppercase “A.”
String operators make use of regular expression matching. This expression matching includes an internal format and a POSIX-compliant format.
PostgreSQL can make use of two distinct types of pattern matching: an ANSI-SQL method and a POSIX regex style. The internal ANSI-SQL style makes use of the LIKE and NOTLIKE keywords. This ANSI-SQL method can use the following wildcards ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access