Data Type precision

From: Jerome Raupach <jraupach(at)intelcom(dot)fr>
To: pgsql-sql(at)postgresql(dot)org
Subject: Data Type precision
Date: 2000-09-26 07:44:21
Message-ID: 39D053D5.80EE373F@intelcom.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

CREATE TABLE TR (f1 FLOAT4, f2 INT4, f3 INT4) ;

UPDATE TR SET f1=f2/f3::FLOAT4 ;

f1 -> xxxxxx,xxxxxx - but I want f1 -> xxxxxx,xx.
(6,6) (6,2)

anybody can help me ?
Thanks. Jerome.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Karel Zak 2000-09-26 08:02:38 Re: Data Type precision
Previous Message Hiroshi Inoue 2000-09-26 02:42:11 Re: SQL functions not locking properly?