agora inbox for pgsql-hackers@postgresql.org
help / color / mirror / Atom feedFrom: Ron Mayer <rm_pg@cheapcomplexdevices.com>
To: Sebastien FLAESCH <sf@4js.com>
Cc: pgsql-general@postgresql.org
Cc: mmoncure@gmail.com
Subject: Re: INTERVAL SECOND limited to 59 seconds?
Date: Sun, 07 Jun 2009 11:59:14 -0700
Message-ID: <4A2C0E02.9070908@cheapcomplexdevices.com> (raw)
In-Reply-To: <4A127038.3010103@4js.com>
References: <4A127038.3010103@4js.com>
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)
view thread (10+ messages) latest in thread
Message-ID: <4A2C0E02.9070908@cheapcomplexdevices.com>
Permalink: ../../4A2C0E02.9070908@cheapcomplexdevices.com/
Also on: postgresql.org/message-id/4A2C0E02.9070908@cheapcomplexdevices.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: rm_pg@cheapcomplexdevices.com, sf@4js.com, pgsql-general@postgresql.org, mmoncure@gmail.com
Subject: Re: INTERVAL SECOND limited to 59 seconds?
In-Reply-To: <4A2C0E02.9070908@cheapcomplexdevices.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox