Received: from localhost (maia-4.hub.org [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 6786E9FB545
	for <pgsql-general-postgresql.org@postgresql.org>;
	Thu, 22 Feb 2007 07:20:18 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024)
	with ESMTP id 86761-06 for
	<pgsql-general-postgresql.org@postgresql.org>;
	Thu, 22 Feb 2007 07:20:15 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from wr-out-0506.google.com (wr-out-0506.google.com
 [64.233.184.225])
	by postgresql.org (Postfix) with ESMTP id 9F8239FB501
	for <pgsql-general@postgresql.org>;
	Thu, 22 Feb 2007 07:20:15 -0400 (AST)
Received: by wr-out-0506.google.com with SMTP id i21so137383wra
	for <pgsql-general@postgresql.org>;
	Thu, 22 Feb 2007 03:20:14 -0800 (PST)
DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type;
	b=E2/WB4AcGKiGJbFMzxnZzTHzabi+0ii10zF0kIsXyL87JVMkD/gqdq0cljtyFVN5+SYZo0eK2AXmxXmpHkVzjX2efD4Ll6Mp2xRdGQaBAW3QwtcRMc/bvRWsUsC8Llr7F0JPlXtFQHuLjGWxB3FNZ0IqkB9OnR8tTIsCiPqDyGQ=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:mime-version:content-type;
	b=EVenlfrCBPxhpqbQHiXiIPI25mJksU0WLSXUyYLDtFWNHp027uXr6awwxlX+mQzt2z5lmzT6UzfvrQK3lirN7mbKLO9CXGWCTZbLrWy26eYUPJZ4ngu+g3mUviMq4ShPEM1kF+EeD8WXKEOa2xXdMeJrMDAMC21ffrxsc2/Dl6s=
Received: by 10.115.54.1 with SMTP id g1mr205858wak.1172143213010;
	Thu, 22 Feb 2007 03:20:13 -0800 (PST)
Received: by 10.114.80.16 with HTTP; Thu, 22 Feb 2007 03:20:12 -0800 (PST)
Message-ID: <bd8b58a40702220320l73b09f23l4a4c6a0c198b0f49@mail.gmail.com>
Date: Thu, 22 Feb 2007 12:20:12 +0100
From: "Rafa Comino" <rafacomino@gmail.com>
To: pgsql-sql@postgresql.org, pgsql-general@postgresql.org
Subject: Esay question, about the numeric format
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_24352_32632431.1172143212942"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.532 tagged_above=0 required=5 tests=AWL, BAYES_20,
	HTML_10_20, HTML_MESSAGE, SPF_PASS
X-Spam-Level: 
X-Archive-Number: 200702/1206
X-Sequence-Number: 109696

------=_Part_24352_32632431.1172143212942
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

------=_Part_24352_32632431.1172143212942
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi every body<br>I have this query<br>SELECT 20.00::numeric(38,2) <br>and postgre gives me 20, i need that postgre gives me 20.00<br>What can i do? i suppose this must be easy, but i dont find how to do ir<br>thanks every body
<br><br>

------=_Part_24352_32632431.1172143212942--