Book Contents

Book Index

Next Topic

Home

ISFINITE

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)