Re: [HACKERS] Patch for ISO-8601-Interval Input and output.

2008-11-10 Thread R Mayer
Brendan Jurd wrote: On Tue, Nov 11, 2008 at 2:36 AM, Ron Mayer I get the expected result from 'P0001', but oddly enough if I specify only the year and month, it pukes: postgres=# select interval 'P0001-01'; Indeed. Thanks again. I've fixed this and added regression tests to check the handling

[HACKERS] 8.3 vs HEAD difference in Interval output?

2008-09-15 Thread R Mayer
Unless I'm compiling stuff wrong, it seems HEAD is giving me slightly different output on Intervals than 8.3 in the roundoff of seconds. 8.3 was rounding to the nearest fraction of a second, HEAD seems to be truncating. In the psql output below it shows 8.3.1 outputting "6.70 secs" while the si