Re: My details

See the attached file for details

From pgsql-docs-owner@postgresql.org Wed Aug 20 10:38:29 2003

X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
by svr1.postgresql.org (Postfix) with ESMTP id 1F325D1B92B
for <pgsql-docs-postgresql.org@localhost.postgresql.org>; Wed, 20 Aug 2003 10:37:33 -0300 (ADT)
Received: from svr1.postgresql.org ([64.117.224.193])
by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024)
with ESMTP id 53326-07
for <pgsql-docs-postgresql.org@localhost.postgresql.org>;
Wed, 20 Aug 2003 10:37:21 -0300 (ADT)
Received: from wolff.to (wolff.to [66.93.249.74])
by svr1.postgresql.org (Postfix) with SMTP id 3107FD1BB86
for <pgsql-docs@postgresql.org>; Wed, 20 Aug 2003 10:37:17 -0300 (ADT)
Received: (qmail 7199 invoked by uid 500); 20 Aug 2003 13:43:07 -0000
Date: Wed, 20 Aug 2003 08:43:07 -0500
From: Bruno Wolff III <bruno@wolff.to>
To: pgsql-docs@postgresql.org
Subject: Time input documentation error
Message-ID: <20030820134307.GA6891@wolff.to>
Mail-Followup-To: pgsql-docs@postgresql.org
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.5.4i
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200308/60
X-Sequence-Number: 1920

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.