Skip site navigation (1) Skip section navigation (2)

Re: My details

From: <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: <pgsql-docs(at)postgresql(dot)org>
Subject: Re: My details
Date: 2003-08-20 08:40:46
Message-ID: 20030820084042.3E66CD1D315@svr1.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-docs
See the attached file for details
>From pgsql-docs-owner(at)postgresql(dot)org  Wed Aug 20 10:38:29 2003
X-Original-To: pgsql-docs-postgresql(dot)org(at)localhost(dot)postgresql(dot)org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 1F325D1B92B
	for <pgsql-docs-postgresql(dot)org(at)localhost(dot)postgresql(dot)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(dot)org(at)localhost(dot)postgresql(dot)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(at)postgresql(dot)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(at)wolff(dot)to>
To: pgsql-docs(at)postgresql(dot)org
Subject: Time input documentation error
Message-ID: <20030820134307(dot)GA6891(at)wolff(dot)to>
Mail-Followup-To: pgsql-docs(at)postgresql(dot)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.

pgsql-docs by date

Next:From: Josh BerkusDate: 2003-08-20 18:02:37
Subject: Can't find thread on Linux memory overcommit
Previous:From: Dan LangilleDate: 2003-08-19 10:08:38
Subject: Re: [HACKERS] What goes into the security doc?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group