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: (view raw or whole thread)
Lists: pgsql-bugs
Operating system:

PostgreSQL version: 
postmaster (PostgreSQL) 7.1.3

psql input:
test=> SELECT timestamp 'infinity' - timestamp 'infinity';

psql output:
 -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

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-2015 The PostgreSQL Global Development Group