↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Functions

upper_inf

Does the range have no upper bound? (An upper bound of Infinity returns false.)

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

group
range
group label
Range/Multirange Functions And Operators
lang
en
layout
table-new
pages
functions-range.html
prose only
false

Definition PG 18

Does the range have no upper bound? (An upper bound of Infinity returns false.)

Signatures and overloads

upper_inf ( anyrange ) → boolean → boolean
Does the range have no upper bound? (An upper bound of Infinity returns false.)
upper_inf ( anymultirange ) → boolean → boolean
Does the multirange have no upper bound? (An upper bound of Infinity returns false.)

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:dc5dd2a0351f0ffa6ad400d93bdac2b0bcca7b8e5be42bb9b45c5b0616ea1434

Text language: en · wiki-repair-20261023:dc5dd2a0351f0ffa6ad400d93bdac2b0bcca7b8e5be42bb9b45c5b0616ea1434