Re: Time input documentation error
Bruno Wolff III <bruno@wolff.to> writes:
area=> select '040506'::time;
ERROR: invalid input syntax for time: "040506"
Mph. This worked in 7.1, but doesn't in 7.2 or later. Also, we will
accept it if it's followed by either fractional seconds or a timezone.
regression=# select '040506-04'::time;
time
----------
04:05:06
(1 row)
regression=# select '040506.12'::time;
time
-------------
04:05:06.12
(1 row)
I'm inclined to say this is a code bug not a doc bug.
regards, tom lane
Import Notes
Reply to msg id not found: 20030820134307.GA6891@wolff.toReference msg id not found: 20030820134307.GA6891@wolff.to
On Wed, Aug 20, 2003 at 16:24:46 -0400,
Tom Lane <tgl@sss.pgh.pa.us> wrote:
I'm inclined to say this is a code bug not a doc bug.
Do I have to do anything more to get it listed as a bug or can I consider
the proper people as having been notified?
Bruno Wolff III wrote:
In table 8.11 in the 7.4 docs the following line:
040506 ISO 8601
suggests that '040506' is a valid input format for time. But in fact
it isn't accepted by either 7.3 or 7.4.For example:
area=> select '040506'::time;
ERROR: invalid input syntax for time: "040506"I built using the intger datetimes option in case that makes a difference.
Seems it is fixed in CVS now:
test=> select '040506'::time;
time
----------
04:05:06
(1 row)
t
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073Import Notes
Reply to msg id not found: 20030820134307.GA6891@wolff.to | Resolved by subject fallback
On Thu, Sep 04, 2003 at 22:45:41 -0400,
Bruce Momjian <pgman@candle.pha.pa.us> wrote:
Seems it is fixed in CVS now:
I think Tom fixed it. He responded to my original message. I wasn't sure
if he was going to do the fix, but I found that it had been fixed at least
a week ago.
Show quoted text
test=> select '040506'::time;
time
----------
04:05:06
(1 row)
t