Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 576429FBA37 for ; Wed, 28 Feb 2007 21:19:58 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 25451-07 for ; Wed, 28 Feb 2007 21:19:55 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from wolff.to (wolff.to [66.93.197.194]) by postgresql.org (Postfix) with SMTP id 610089FB491 for ; Wed, 28 Feb 2007 21:19:55 -0400 (AST) Received: (qmail 5773 invoked by uid 500); 1 Mar 2007 01:19:52 -0000 Date: Wed, 28 Feb 2007 19:19:52 -0600 From: Bruno Wolff III To: Rafa Comino Cc: pgsql-sql@postgresql.org, pgsql-general@postgresql.org Subject: Re: Esay question, about the numeric format Message-ID: <20070301011952.GA5007@wolff.to> Mail-Followup-To: Bruno Wolff III , Rafa Comino , pgsql-sql@postgresql.org, pgsql-general@postgresql.org References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/1698 X-Sequence-Number: 110187 On Thu, Feb 22, 2007 at 12:20:12 +0100, Rafa Comino wrote: > Hi every body > I have this query > SELECT 20.00::numeric(38,2) > and postgre gives me 20, i need that postgre gives me 20.00 > What can i do? i suppose this must be easy, but i dont find how to do ir > thanks every body If the exact output format matters, you should probably use to_char to convert the number to a string.