Received: from primaire.intelcom.fr (primaire.intelcom.fr [194.250.33.1]) by hub.org (8.10.1/8.10.1) with ESMTP id e8Q7inN70963 for ; Tue, 26 Sep 2000 03:44:49 -0400 (EDT) Received: from volvo.intelcom.fr ([192.168.160.20]) by primaire.intelcom.fr (8.8.8+Sun/8.8.8) with SMTP id JAA19562 for ; Tue, 26 Sep 2000 09:44:25 +0200 (MET DST) Received: from intelcom.fr by volvo.intelcom.fr (SMI-8.6/SMI-SVR4) id JAA28158; Tue, 26 Sep 2000 09:44:22 +0200 Message-ID: <39D053D5.80EE373F@intelcom.fr> Date: Tue, 26 Sep 2000 09:44:21 +0200 From: Jerome Raupach X-Mailer: Mozilla 4.75 [en] (X11; U; SunOS 5.5 sun4d) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Data Type precision Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200009/211 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.