Decimal ?? - Mailing list pgsql-sql

From Tubagus Nizomi
Subject Decimal ??
Date
Msg-id 00052410061402.00709@nizomi.dnet.net.id
Whole thread Raw
Responses Re: Decimal ??  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
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 


pgsql-sql by date:

Previous
From: stef@chronozon.dyndns.org (Stef telford)
Date:
Subject: Clarified Question
Next
From: Jason Earl
Date:
Subject: Re: Decimal ??