ENC: Datatype time PostGreSql 7.2.1 - Mailing list pgsql-general

From Daniel Ferreira Felix
Subject ENC: Datatype time PostGreSql 7.2.1
Date
Msg-id 11C113B93D56D311B985005004994309F86CFB@SRV_EXCHANGE0
Whole thread Raw
List pgsql-general


        I am brazilian and work with o database PostGreSql 7.1.3.
        I am upgrade PostGreSql 7.1.3 to 7.2.1 and find some bugs insert dataype time .

        Example :

                Create table teste( hour time);

                 \d teste
                                        Table "teste"
                         Column |          Type          | Modifiers
                        --------+------------------------+-----------
                        hour   | time without time zone |             

                Insert into teste values ('080000');
                ERROR:  Bad time external representation '080000'

                insert into teste values ('08:00:00');
                INSERT 19128 1

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

        Thanks.
               

Daniel Ferreira Felix
Analista de Sistemas
Tecnet Teleinformática Ltda
e-mail : daniel_felix@tecnet.ind.br

pgsql-general by date:

Previous
From: "Pierre-Alexis Paquin"
Date:
Subject: Postgresql installation problem
Next
From: "Bob Powell"
Date:
Subject: Export From Postresql to a DBF File Format