Functions / String Functions And Operators

upper

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

Reading PG 18current·documented in 27 of 27 versions, 7.1 to 20

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 5

Definition snapshot: b7bd9cda · English manual source