Received: from druid.net (root@druid.net [216.126.72.98])
	by hub.org (8.9.3/8.9.3) with ESMTP id IAA79503
	for <pgsql-sql@postgreSQL.org>; Tue, 13 Jul 1999 08:54:33 -0400 (EDT)
	(envelope-from darcy@druid.net)
Received: from localhost (1106 bytes) by druid.net
	via sendmail with P:stdio/R:bind_hosts/T:inet_zone_bind_smtp
	(sender: <darcy>) (ident <darcy> using unix)
	id <m11423F-0000bFC@druid.net>
	for <pgsql-sql@postgreSQL.org>; Tue, 13 Jul 1999 08:52:49 -0400 (EDT)
	(Smail-3.2.0.104 1998-Nov-20 #4 built 1999-Apr-13)
Message-Id: <m11423F-0000bFC@druid.net>
Subject: Re: [SQL] calculating percentages
In-Reply-To: <Pine.LNX.3.96.990712104853.16755A-100000@mailhost.nrnet.org>
	from Thomas Good at "Jul 12, 1999 10:50:27 am"
To: tomg@nrnet.org (Thomas Good)
Date: Tue, 13 Jul 1999 08:52:49 -0400 (EDT)
From: "D'Arcy" "J.M." Cain <darcy@druid.net>
Cc: tgl@sss.pgh.pa.us, tomg@admin.nrnet.org, pgsql-sql@postgreSQL.org
Reply-To: pgsql-sql@postgreSQL.org
X-Mailer: ELM [version 2.4ME+ PL50 (25)]
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

Thus spake Thomas Good
> > > How does one do this:   SELECT (current_value/target) * 100;
> The divison rtns 0, which multiplied by 100, rtns 0.

Does "SELECT (current_value * 100)/target" work better?

-- 
D'Arcy J.M. Cain <darcy@{druid|vex}.net>   |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 424 2871     (DoD#0082)    (eNTP)   |  what's for dinner.