Received: from shaked.cc.openu.ac.il (shaked.cc.openu.ac.il [147.233.145.65]) by hub.org (8.9.1/8.9.1) with ESMTP id JAA10897 for ; Mon, 7 Dec 1998 09:13:22 -0500 (EST) (envelope-from herouth@oumail.openu.ac.il) Received: from [147.233.159.109] (herouth@mac-herouth.pc.openu.ac.il [147.233.159.109]) by shaked.cc.openu.ac.il (8.8.8/8.8.8) with ESMTP id QAA23119; Mon, 7 Dec 1998 16:12:59 +0200 (IST) X-Sender: herouth@shaked.cc.openu.ac.il Message-Id: In-Reply-To: <366B8AF0.70AA02B0@mandanet.ch> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Date: Mon, 7 Dec 1998 16:14:23 +0200 To: Jerome Knobl From: Herouth Maoz Subject: Re: [SQL] Howto format a float8 number? Cc: pgsql-sql@postgreSQL.org At 9:59 +0200 on 7/12/98, Jerome Knobl wrote: > I want to print a floating number like this : > 10.1 -> 10.10 > or : 10000.1 -> 10'000.10 > or : 0 -> 0.00 > etc... To the best of my knowledge, you do that on the Front End, using the formatting facilities of whatever language you are using for your application. Herouth -- Herouth Maoz, Internet developer. Open University of Israel - Telem project http://telem.openu.ac.il/~herutma