FUNCTIONS / STRING FUNCTIONS AND OPERATORS

lower

Converts the string to all lower case, according to the rules of the database's locale.

Signatures & examples

lower ( text ) → text

Converts the string to all lower case, according to the rules of the database's locale.

lower('TOM') → tom

lower ( anyrange ) → anyelement

Extracts the lower bound of the range (NULL if the range is empty or has no lower bound).

lower(numrange(1.1,2.2)) → 1.1

lower ( anymultirange ) → anyelement

Extracts the lower bound of the multirange (NULL if the multirange is empty or has no lower bound).

lower('{[1.1,2.2)}'::nummultirange) → 1.1

Version history 3

Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source