Postgres Pro
Downloads
Home   >   mailing lists

Data Type precision - Mailing list pgsql-sql

From Jerome Raupach
Subject Data Type precision
Date
Msg-id 39D053D5.80EE373F@intelcom.fr
Whole thread Raw
Responses Re: Data Type precision
List pgsql-sql
Tree view 
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.

pgsql-sql by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: SQL functions not locking properly?
Next
From: Karel Zak
Date:
Subject: Re: Data Type precision