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

Re: Time input documentation error

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Bruno Wolff III <bruno(at)wolff(dot)to>
Cc: pgsql-docs(at)postgresql(dot)org
Subject: Re: Time input documentation error
Date: 2003-09-05 02:45:41
Message-ID: 200309050245.h852jfT20197@candle.pha.pa.us (view raw or flat)
Thread:
Lists: 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(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Responses

pgsql-docs by date

Next:From: Bruno Wolff IIIDate: 2003-09-05 19:11:14
Subject: Re: Time input documentation error
Previous:From: Neil ConwayDate: 2003-09-05 00:21:21
Subject: minor documentation improvements

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