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

Re: Time input documentation error

From: Tom Lane <tgl(at)sss(dot)pgh(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-08-20 20:24:46
Message-ID: 18233.1061411086@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-docs
Bruno Wolff III <bruno(at)wolff(dot)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

Responses

pgsql-docs by date

Next:From: Bruno Wolff IIIDate: 2003-08-21 02:38:43
Subject: Re: Time input documentation error
Previous:From: Thomas SwanDate: 2003-08-20 18:35:35
Subject: Re: Can't find thread on Linux memory overcommit

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