Received: from localhost (wm.hub.org [200.46.204.128])
	by postgresql.org (Postfix) with ESMTP id C8FD69FB3C9
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 31 Oct 2006 15:43:35 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024)
	with ESMTP id 19676-03-2 for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 31 Oct 2006 19:43:12 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.175])
	by postgresql.org (Postfix) with ESMTP id 88E189FB586
	for <pgsql-sql@postgresql.org>; Tue, 31 Oct 2006 15:35:19 -0400 (AST)
Received: by ug-out-1314.google.com with SMTP id 30so1349676ugc
	for <pgsql-sql@postgresql.org>; Tue, 31 Oct 2006 11:35:18 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:mime-version:content-type;
	b=JLlwjX0WwWUDAuBdoJWeXE+iBrtqzFQrX4x1ZXAW/OMhmAQbHkW2eO9Wathvd2a6GPa7Sw1Jy7Wxay61Uu21vOSwXszb2IPYK6ZRTV5X0lwsqwqU+yzvKoFTovAQeW3qfLC/dgxok4n+nYMR7Ct1lFofKNbCAYbaLAQWWLahQVU=
Received: by 10.66.216.20 with SMTP id o20mr6681686ugg;
	Tue, 31 Oct 2006 11:35:17 -0800 (PST)
Received: by 10.67.118.11 with HTTP; Tue, 31 Oct 2006 11:35:17 -0800 (PST)
Message-ID: <55c095e90610311135l101f6a91s433e6d7e5b90cb7c@mail.gmail.com>
Date: Tue, 31 Oct 2006 17:35:17 -0200
From: "Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Round Numeric Type
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_14844_14067913.1162323317570"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200610/251
X-Sequence-Number: 26640

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

Hi list,

I did a trigger to update a points on a table but in some cases the
PostgreSQL does a round of my Numeric like.

If >= 0.5 so postgresql puts 1
If < 0.5 so postgresql puts 0

Did anybody knows if it is possible to control this matter ?


Regards
Ezequias

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

Hi list,<br><br>I did a trigger to update a points on a table but in some cases the PostgreSQL does a round of my Numeric like.<br><br>If &gt;= 0.5 so postgresql puts 1<br>If &lt; 0.5 so postgresql puts 0<br><br>Did anybody knows if it is possible to control this matter ?
<br><br><br>Regards<br>Ezequias

------=_Part_14844_14067913.1162323317570--