Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-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
> 

pgsql-bugs by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group