Functions / Range/Multirange Functions And Operators

lower_inf

Does the range have no lower bound? (A lower bound of -Infinity returns false.)

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

Signatures & examples

lower_inf ( anyrange ) → boolean

Does the range have no lower bound? (A lower bound of -Infinity returns false.)

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

lower_inf ( anymultirange ) → boolean

Does the multirange have no lower bound? (A lower bound of -Infinity returns false.)

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

Version history 4

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