Skip site navigation (1) Skip section navigation (2)

Bug(?) around 'infinity'

From: Fduch the Pravking <fduch(at)antar(dot)bryansk(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug(?) around 'infinity'
Date: 2002-01-24 20:19:36
Message-ID: 20020124231936.B24565@zombie.antar.bryansk.ru (view raw or flat)
Thread:
Lists: 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

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2002-01-24 20:27:27
Subject: Re: Bug(?) around 'infinity'
Previous:From: Tom LaneDate: 2002-01-24 18:28:56
Subject: Re: Bug #568: RULE ON SELECT with old values.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group