Received: from trends.net (root@clio.trends.ca [209.47.148.2]) by hub.org (8.9.1/8.9.1) with ESMTP id IAA05515 for ; Mon, 7 Dec 1998 08:53:58 -0500 (EST) (envelope-from jknobl@mandanet.ch) Received: from lucas.mandanet.ch (lucas.mandanet.ch [195.15.14.8]) by trends.net (8.8.8/8.8.8) with SMTP id FAA00854 for ; Mon, 7 Dec 1998 05:23:19 -0500 (EST) Received: from thomas.mandanet.ch (thomas.mandanet.ch [195.15.14.68]) by lucas.mandanet.ch (NTMail 3.02.13) with ESMTP id ya013674 for ; Mon, 7 Dec 1998 08:59:44 +0000 Message-ID: <366B8AF0.70AA02B0@mandanet.ch> Date: Mon, 07 Dec 1998 08:59:44 +0100 From: Jerome Knobl Organization: MandaNET X-Mailer: Mozilla 4.5b2 [en] (WinNT; I) X-Accept-Language: fr-CH MIME-Version: 1.0 To: pgsql-sql@postgreSQL.org Subject: Howto format a float8 number? Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello, I'm sorry, I look all the documentation, but I didn't find how to format a float8 number. I want to print a floating number like this : 10.1 -> 10.10 or : 10000.1 -> 10'000.10 or : 0 -> 0.00 etc... If you have some idea, write my! Thank a lot. JK