ISFINITE tests for the special TIMESTAMP constant INFINITY and returns a value of type BOOLEAN;
Syntax
ISFINITE(
timestamp)
Semantics
timestamp |
an expression of type TIMESTAMP |
Examples
> SELECT ISFINITE(TIMESTAMP '2001-02-16 21:28:30');
isfinite
----------
t
(1 row)
> SELECT ISFINITE(TIMESTAMP 'INFINITY');
isfinite
----------
f
(1 row)