Re: INTERVAL SECOND limited to 59 seconds?
| От | Ron Mayer |
|---|---|
| Тема | Re: INTERVAL SECOND limited to 59 seconds? |
| Дата | |
| Msg-id | 4A2C0E02.9070908@cheapcomplexdevices.com обсуждение исходный текст |
| Ответ на | INTERVAL SECOND limited to 59 seconds? (Sebastien FLAESCH <sf@4js.com>) |
| Ответы |
Re: INTERVAL SECOND limited to 59 seconds?
Re: INTERVAL SECOND limited to 59 seconds? |
| Список | 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 по дате отправления: