upper

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

English manual coverage begins with PostgreSQL 7.1. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

7.1 7.2 7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

group: string
group label: 字符串函数和操作符
lang: en
layout: table-new
pages: functions-string.html, functions-range.html
prose only: false

Definition PG 18

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

Signatures and overloads

upper ( text ) → text → text

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

upper ( anyrange ) → anyelement → anyelement

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

upper ( anymultirange ) → anyelement → anyelement

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

Compare versions

Complete source facts

documentation revision

{"inputs":[{"file":"functions-range.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"adc48b5f4dd16fd7079e4b9821ef1877bf4bfa89274da44982672598fe53f9a5","version":"18.7"},{"file":"functions-string.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"dbe9f91e55c35969d99a8d2697b6f7bd5388a24ccc2b89706a666f176025f1e2","version":"18.7"},{"file":"functions-range.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"0cf73372e4a803a8728ac799c436646b9273bfbf0bf645cee112401eaff4de59","version":"18.7"},{"file":"functions-string.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"7eecd3bb343149124be0476a539f3c682476eab2a15489a0e0ad06fbb769ea9e","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}

Source references

Original manual reference

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:47ed20d5d88be11d089e24df61b2a374e21326ea6ed080aecb3234a4cadc3090

Text language: en · wiki-repair-20261023:47ed20d5d88be11d089e24df61b2a374e21326ea6ed080aecb3234a4cadc3090