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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly