Re: INTERVAL SECOND limited to 59 seconds? - Mailing list pgsql-general

From Ron Mayer
Subject Re: INTERVAL SECOND limited to 59 seconds?
Date
Msg-id 4A2C0E02.9070908@cheapcomplexdevices.com
Whole thread Raw
In response to INTERVAL SECOND limited to 59 seconds?  (Sebastien FLAESCH <sf@4js.com>)
Responses Re: INTERVAL SECOND limited to 59 seconds?
Re: INTERVAL SECOND limited to 59 seconds?
List pgsql-general
Finally got around to looking at this thread.
Looks like the original questions from the thread
got resolved, but I found this behaviour surprising:

regression=# select interval '1' day to second;
 interval
----------
 @ 1 hour
(1 row)

Should this be 1 second?
If so I can send a patch.





regression=# select version();
                                                  version
-----------------------------------------------------------------------------------------------------------
 PostgreSQL 8.4beta2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.2.4 (Ubuntu 4.2.4-1ubuntu3), 32-bit
(1 row)

pgsql-general by date:

Previous
From: "Shakil Shaikh"
Date:
Subject: Using ANY()
Next
From: Tom Lane
Date:
Subject: Re: INTERVAL SECOND limited to 59 seconds?