Documentation

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

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

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

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' LIKE E'a%')

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' ILIKE E'a%')