Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 028FB9FB6EA; Thu, 22 Feb 2007 07:27:35 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 60116-03; Thu, 22 Feb 2007 07:27:25 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.186]) by postgresql.org (Postfix) with ESMTP id B2E7E9FB4EE; Thu, 22 Feb 2007 07:27:28 -0400 (AST) Received: from [194.25.154.138] (helo=webserv.wug.de) by mrelayeu.kundenserver.de (node=mrelayeu0) with ESMTP (Nemesis), id 0MKwh2-1HKC6g2nP0-0004YP; Thu, 22 Feb 2007 12:27:27 +0100 Received: from kretschmer by webserv.wug.de with local (Exim 3.36 #1) id 1HKC6f-0006SB-00; Thu, 22 Feb 2007 12:27:25 +0100 Date: Thu, 22 Feb 2007 12:27:25 +0100 From: "A. Kretschmer" To: pgsql-general@postgresql.org, pgsql-sql@postgresql.org Subject: Re: Esay question, about the numeric format Message-ID: <20070222112725.GC15488@a-kretschmer.de> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-OS: Debian/GNU Linux - weil ich es mir Wert bin! X-Message-Flag: "Windows" is not the answer. "Windows" is the question and the answer is "no"! User-Agent: Mutt/1.5.9i X-Provags-ID: kundenserver.de abuse@kundenserver.de login:51ea9561fc3f6d9539a2acd743e4748c X-Provags-ID2: V01U2FsdGVkX197K6dzHXiGy+Rkkhv5nLgmW0fBisry8PzMOeNSGMz5dH68Y4Ge0jlgG9XZPS4t+VeCxLNfylRcLfw++ktDFzMjyGNyB3qQImuRMeMlWHYJ5oAE+gO0jm4x X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.454 tagged_above=0 required=5 tests=AWL, BAYES_50, SPF_HELO_PASS X-Spam-Level: X-Archive-Number: 200702/1207 X-Sequence-Number: 109697 am Thu, dem 22.02.2007, um 12:20:12 +0100 mailte Rafa Comino folgendes: > 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 Works for me: (version 8.1) test=*# SELECT 20.00::numeric(38,2); numeric --------- 20.00 (1 row) test=*# SELECT 20.00::numeric(38,20); numeric ------------------------- 20.00000000000000000000 (1 row) Btw.: http://stoned.homeunix.org/~itsme/postgre/ Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net