Received: from shaked.cc.openu.ac.il (shaked.cc.openu.ac.il [147.233.145.65]) by hub.org (8.8.8/8.7.5) with ESMTP id JAA21220 for ; Mon, 6 Jul 1998 09:50:38 -0400 (EDT) Received: from [147.233.159.109] (herouth@mac-herouth.pc.openu.ac.il [147.233.159.109]) by shaked.cc.openu.ac.il (8.8.5/8.8.5) with ESMTP id QAA04304; Mon, 6 Jul 1998 16:49:36 +0300 (IDT) X-Sender: herouth@shaked.cc.openu.ac.il Message-Id: In-Reply-To: <35A09973.15A3@cdg.co.th> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Date: Mon, 6 Jul 1998 16:49:26 +0300 To: Korapat Charukumnerdkanok From: Herouth Maoz Subject: Re: [GENERAL] :) Import file2table Question Cc: pgsql-sql@postgreSQL.org (Redirected to the SQL list) At 12:31 +0300 on 6/7/98, Korapat Charukumnerdkanok wrote: > 2 -What table field type that suits for 6-digit decimal number.. > (i.e. 0.000000, 0.250001 , 0.123456 , ....)? > > I've defined this column with float4 and float8 > but when I inserted data it returned this error message.. > > > ProjDB=> insert into PrjTB values (0.000000,'red','Ln1') > ProjDB->; > ERROR: pg_atoi: error in "0.000000": can't parse ".000000" Must be something wrong with your installation - or your table definition. In my case: testing=> create table test ( col1 float8 ); CREATE testing=> insert into test values ( 0.3 ); INSERT 758126 1 testing=> insert into test values ( 0.000003 ); INSERT 758127 1 testing=> insert into test values ( 0 ); INSERT 758128 1 testing=> insert into test values ( 0.0 ); INSERT 758129 1 testing=> insert into test values ( 0.000000 ); INSERT 758130 1 testing=> select * from test; col1 ----- 0.3 3e-06 0 0 0 (5 rows) Herouth -- Herouth Maoz, Internet developer. Open University of Israel - Telem project http://telem.openu.ac.il/~herutma