Functions / Range/Multirange Functions And Operators

upper_inf

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

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

Signatures & examples

upper_inf ( anyrange ) → boolean

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

upper_inf('(,)'::daterange) → t

upper_inf ( anymultirange ) → boolean

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

upper_inf('{(,)}'::datemultirange) → t

Version history 4

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