FUNCTIONS / STRING FUNCTIONS AND OPERATORS

upper

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

Signatures & examples

upper ( text ) → text

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

upper('tom') → TOM

upper ( anyrange ) → anyelement

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

upper(numrange(1.1,2.2)) → 2.2

upper ( anymultirange ) → anyelement

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

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

Version history 3

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