Text Function

>>> printSQL $ lower "ARRRGGG"
lower((E'ARRRGGG' :: text))

>>> printSQL $ upper "eeee"
upper((E'eeee' :: text))

>>> printSQL $ charLength "four"
char_length((E'four' :: text))

The like expression returns true if the string matches the supplied pattern. If pattern does not contain percent signs or underscores, then the pattern only represents the string itself; in that case like acts like the equals operator. An underscore (_) in pattern stands for (matches) any single character; a percent sign (%) matches any sequence of zero or more characters.

>>> printSQL $ "abc" `like` "a%"
((E'abc' :: text) LIKE (E'a%' :: text))

The key word ILIKE can be used instead of LIKE to make the match case-insensitive according to the active locale.

>>> printSQL $ "abc" `ilike` "a%"
((E'abc' :: text) ILIKE (E'a%' :: text))