Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2])
	by hub.org (8.9.3/8.9.3) with ESMTP id LAA92871
	for <pgsql-sql@postgreSQL.org>; Mon, 12 Jul 1999 11:08:02 -0400 (EDT)
	(envelope-from tgl@sss.pgh.pa.us)
Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id LAA20272;
	Mon, 12 Jul 1999 11:06:57 -0400 (EDT)
To: Thomas Good <tomg@admin.nrnet.org>
cc: "PostgreSQL::SQL List" <pgsql-sql@postgreSQL.org>
Subject: Re: [SQL] calculating percentages 
In-reply-to: Your message of Mon, 12 Jul 1999 09:50:15 -0400 (EDT)
	<Pine.LNX.3.96.990712094714.3092A-100000@admin.nrnet.org>
Date: Mon, 12 Jul 1999 11:06:56 -0400
Message-ID: <20270.931792016@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

Thomas Good <tomg@admin.nrnet.org> writes:
> How does one do this:   SELECT (current_value/target) * 100;
> in postgres?  

Pretty much just like that.  What problem are you having?

			regards, tom lane