↑↓ select ↵ open ⌫ change scope Open full search

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

Functions / Date/Time Functions And Operators

isfinite

Read the PG 18 manual

Test for finite date (not +/-infinity)

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

7.17.27.37.48.08.18.28.38.49.09.19.29.39.49.59.61011121314151617181920

Signatures & examples

isfinite ( date ) → boolean
Test for finite date (not +/-infinity)
isfinite(date '2001-02-16') → true
isfinite ( timestamp ) → boolean
Test for finite timestamp (not +/-infinity)
isfinite(timestamp 'infinity') → false
isfinite ( interval ) → boolean
Test for finite interval (not +/-infinity)
isfinite(interval '4 hours') → true
Version history 3
  1. 12 → 13 changed
  2. 8.3 → 8.4 changed
  3. 7.3 → 7.4 changed

Definition snapshot: b7bd9cda · English manual source