Received: from smtp.dnet.net.id (IDENT:qmailr@engine9.dnet.net.id [202.148.1.21]) by hub.org (8.9.3/8.9.3) with SMTP id XAA25583 for ; Tue, 23 May 2000 23:04:23 -0400 (EDT) (envelope-from nizomi@dnet.net.id) Received: (qmail 871 invoked from network); 24 May 2000 10:00:57 +0700 Received: from nizomi.dnet.net.id (nizomi@202.148.1.198) by engine9.dnet.net.id with SMTP; 24 May 2000 10:00:57 +0700 From: Tubagus Nizomi To: pgsql-sql@postgresql.org Subject: Decimal ?? Date: Wed, 24 May 2000 09:55:51 +0700 X-Mailer: KMail [version 1.0.28] Content-Type: text/plain MIME-Version: 1.0 Message-Id: <00052410061402.00709@nizomi.dnet.net.id> Content-Transfer-Encoding: 8bit X-Archive-Number: 200005/114 I have table : create table test (name text, price numeric(6,2)); CREATE insert into test values ('John',0.75); INSERT select * from test; name | price --------- John | 0.75 but when i insert into test values ('John',3/4); INSERT select * from test; name | price --------- John | 0.00 ---> ??? why this value 0.00 but i want to 0.75 ??? help me please. i am using mandrake 7 and postgres 6.5.3 Thanks Nizomi