Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.9.3/8.9.3) with ESMTP id AAA09593 for ; Wed, 24 May 2000 00:44:38 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id AAA05823; Wed, 24 May 2000 00:44:30 -0400 (EDT) To: Tubagus Nizomi cc: pgsql-sql@postgresql.org Subject: Re: Decimal ?? In-reply-to: <00052410061402.00709@nizomi.dnet.net.id> References: <00052410061402.00709@nizomi.dnet.net.id> Comments: In-reply-to Tubagus Nizomi message dated "Wed, 24 May 2000 09:55:51 +0700" Date: Wed, 24 May 2000 00:44:30 -0400 Message-ID: <5820.959143470@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200005/116 Tubagus Nizomi writes: > I have table : > create table test (name text, price numeric(6,2)); > but when i insert into test values ('John',3/4); > why this value 0.00 but i want to 0.75 ??? help me please. Offhand I'd bet that "3/4" is being interpreted as an integer division expression. Try "3.0/4.0" or some such if you want a fractional result... regards, tom lane