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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-docs by date

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