Re: Datatype time PostGreSql 7.2.1

I am brazilian and work with o database PostGreSql 7.1.3.

Bom dia!

I am upgrade PostGreSql 7.1.3 to 7.2.1 and find some bugs
insert dataype time . <snip>

lockhart=# select time '030000';
ERROR: Bad time external representation '030000'

This is a bug or new pattern ?
The manuals show that it is possible insert with the format hhmmss.

Hmm. It certainly does not now work; I'm not sure exactly when it
changed. What *does* work at the moment is an ISO-8601 representation:

lockhart=# select time 't030000';
time
----------
03:00:00

which is not of course exactly what you want. I'll look at
re-introducing the capability for time fields. Sorry for the
incompatibility.

If you are building PostgreSQL from source, you might have time to put
your test case into the pgsql/src/test/regress/sql/time.sql test file to
make sure it gets covered in future releases. Send a patch to the list
or to me directly and we'll include it.

hth

- Thomas