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

Re: Bug(?) around 'infinity'

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Fduch the Pravking <fduch(at)antar(dot)bryansk(dot)ru>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug(?) around 'infinity'
Date: 2002-01-24 20:27:27
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
Fduch the Pravking <fduch(at)antar(dot)bryansk(dot)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

In response to

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2002-01-25 02:04:55
Subject: Re: COPY when 'filename' is a directory
Previous:From: Fduch the PravkingDate: 2002-01-24 20:19:36
Subject: Bug(?) around 'infinity'

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