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

Fduch the Pravking <fduch@antar.bryansk.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