Re: 8.3 vs HEAD difference in Interval output? - Mailing list pgsql-hackers

From Ron Mayer
Subject Re: 8.3 vs HEAD difference in Interval output?
Date
Msg-id 48CEE156.5080203@cheapcomplexdevices.com
Whole thread Raw
In response to Re: 8.3 vs HEAD difference in Interval output?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> 
> This is not the only place where the float-timestamps code has rounding
> behavior that doesn't appear in the integer-timestamps code. 

Yeah... For that matter, I find this surprising as well:

regression=# select '0.7 secs'::interval, ('7 secs'::interval/10);    interval     |  ?column?
-----------------+------------- 00:00:00.699999 | 00:00:00.70
(1 row)

I'll start making a list of them for a future patch down the road.


pgsql-hackers by date:

Previous
From: R Mayer
Date:
Subject: 8.3 vs HEAD difference in Interval output?
Next
From: Tom Lane
Date:
Subject: Coping with nLocks overflow