pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: Time input documentation error
4+ messages / 3 participants
[nested] [flat]
* Re: Time input documentation error
@ 2003-08-20 20:24 ` Tom Lane <tgl@sss.pgh.pa.us>
2003-08-21 02:38 ` Re: Time input documentation error Bruno Wolff III <bruno@wolff.to>
1 sibling, 1 reply; 4+ messages in thread
From: Tom Lane @ 2003-08-20 20:24 UTC (permalink / raw)
To: Bruno Wolff III <bruno@wolff.to>; +Cc: pgsql-docs
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Time input documentation error
2003-08-20 20:24 ` Re: Time input documentation error Tom Lane <tgl@sss.pgh.pa.us>
@ 2003-08-21 02:38 ` Bruno Wolff III <bruno@wolff.to>
0 siblings, 0 replies; 4+ messages in thread
From: Bruno Wolff III @ 2003-08-21 02:38 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-docs
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?
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Time input documentation error
@ 2003-09-05 02:45 ` Bruce Momjian <pgman@candle.pha.pa.us>
2003-09-05 19:11 ` Re: Time input documentation error Bruno Wolff III <bruno@wolff.to>
1 sibling, 1 reply; 4+ messages in thread
From: Bruce Momjian @ 2003-09-05 02:45 UTC (permalink / raw)
To: Bruno Wolff III <bruno@wolff.to>; +Cc: pgsql-docs
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 19073
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Time input documentation error
2003-09-05 02:45 ` Re: Time input documentation error Bruce Momjian <pgman@candle.pha.pa.us>
@ 2003-09-05 19:11 ` Bruno Wolff III <bruno@wolff.to>
0 siblings, 0 replies; 4+ messages in thread
From: Bruno Wolff III @ 2003-09-05 19:11 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: pgsql-docs
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.
> test=> select '040506'::time;
> time
> ----------
> 04:05:06
> (1 row)
> t
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2003-09-05 19:11 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-08-20 20:24 ` Tom Lane <tgl@sss.pgh.pa.us>
2003-08-21 02:38 ` Bruno Wolff III <bruno@wolff.to>
2003-09-05 02:45 ` Bruce Momjian <pgman@candle.pha.pa.us>
2003-09-05 19:11 ` Bruno Wolff III <bruno@wolff.to>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox