Обсуждение: Time input documentation error

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.

P.S.
Appologies if you received this twice. I tried to send in this report
a couple of days ago, but never saw the message come back through the
list server, so i am assuming I screwed up sending the message.

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

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 19073

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