| 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: | 19948.1011904047@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2002-01-25 02:04:55 | Re: COPY when 'filename' is a directory |
| Previous Message | Fduch the Pravking | 2002-01-24 20:19:36 | Bug(?) around 'infinity' |