Operating system:
FreeBSD 4.4-STABLE
PostgreSQL version:
postmaster (PostgreSQL) 7.1.3
psql input:
test=> SELECT timestamp 'infinity' - timestamp 'infinity';
psql output:
?column?
-------------------------------------------------
-2147483648 days --2147483648:-2147483648:00NaN
(1 row)
In the documentation, nothing said about 'infinity' and '-infinity'
timestamp values, except that the first is later than other valid times,
and the second is earlier than other valid times.
Sorry if my English is poor.
--
Fduch M. Pravking