Bug(?) around 'infinity' - Mailing list pgsql-bugs

From Fduch the Pravking
Subject Bug(?) around 'infinity'
Date
Msg-id 20020124231936.B24565@zombie.antar.bryansk.ru
Whole thread Raw
Responses Re: Bug(?) around 'infinity'  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bug #568: RULE ON SELECT with old values.
Next
From: Tom Lane
Date:
Subject: Re: Bug(?) around 'infinity'