Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group