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
>
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 |
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# |