ISFINITE
Tests for the special TIMESTAMP constant INFINITY
and returns a value of type BOOLEAN.
Behavior Type
Syntax
ISFINITE (
timestamp)
Parameters
timestamp |
Expression of type TIMESTAMP |
Examples
SELECT ISFINITE(TIMESTAMP '2009-02-16 21:28:30'); ISFINITE ---------- t (1 row)
SELECT ISFINITE(TIMESTAMP 'INFINITY'); ISFINITE ---------- f (1 row)