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