ENC: Datatype time PostGreSql 7.2.1

From: Daniel Ferreira Felix <daniel_felix(at)tecnet(dot)ind(dot)br>
To: "'pgsql-bugs(at)postgresql(dot)org'" <pgsql-bugs(at)postgresql(dot)org>
Cc: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: ENC: Datatype time PostGreSql 7.2.1
Date: 2002-04-10 13:51:37
Message-ID: 11C113B93D56D311B985005004994309F86CFB@SRV_EXCHANGE0
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs 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(at)tecnet(dot)ind(dot)br
>

Browse pgsql-bugs by date

  From Date Subject
Next Message pgsql-bugs 2002-04-10 21:49:48 Bug #631: pg_dumpall does not accept -F or -f
Previous Message Sean Chittenden 2002-04-10 06:45:33 Re: Bug #630: date/time storage problem: timestamp parsed

Browse pgsql-general by date

  From Date Subject
Next Message Johann Zuschlag 2002-04-10 13:55:33 Re: Why does this not work? (keyword 'TEXT')
Previous Message Daniel Morgan 2002-04-10 13:04:55 Re: PostgreSQL and C#