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@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073