Bug(?) around 'infinity'
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
Fduch the Pravking <fduch@antar.bryansk.ru> writes:
postmaster (PostgreSQL) 7.1.3
psql input:
test=> SELECT timestamp 'infinity' - timestamp 'infinity';
psql output:
?column?
-------------------------------------------------
-2147483648 days --2147483648:-2147483648:00NaN
(1 row)
In current sources (7.2RC2, more or less) I get
regression=# SELECT timestamp 'infinity' - timestamp 'infinity';
ERROR: Unable to subtract non-finite timestamps
So this has apparently been dealt with...
regards, tom lane