Received: from tidal.ipinc.com (tidal.ipinc.com [199.245.188.85]) by hub.org (8.10.1/8.10.1) with ESMTP id e8QHjEN37180 for ; Tue, 26 Sep 2000 13:45:14 -0400 (EDT) Received: from ipinc.com (jliang.ipinc.com [199.245.188.130]) by tidal.ipinc.com (8.9.3/8.9.3) with ESMTP id KAA48859; Tue, 26 Sep 2000 10:45:05 -0700 (PDT) (envelope-from jliang@ipinc.com) Message-ID: <39D0DFC0.A4C00EFA@ipinc.com> Date: Tue, 26 Sep 2000 10:41:20 -0700 From: Jie Liang Organization: ipinc.com X-Mailer: Mozilla 4.7 [en] (X11; U; FreeBSD 3.4-RELEASE i386) X-Accept-Language: en MIME-Version: 1.0 To: Jerome Raupach CC: pgsql-sql@postgresql.org Subject: Re: Data Type precision References: <39D053D5.80EE373F@intelcom.fr> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200009/214 Hi, there, You can use function: urldb=# select round(234.356534,2); round -------- 234.36 (1 row) Jerome Raupach wrote: > 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. -- Jie LIANG Internet Products Inc. 10350 Science Center Drive Suite 100, San Diego, CA 92121 Office:(858)320-4873 jliang@ipinc.com www.ipinc.com