Received: from mail1.panix.com (mail1.panix.com [166.84.0.212]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA81195 for ; Mon, 12 Jul 1999 09:48:37 -0400 (EDT) (envelope-from tomg@admin.nrnet.org) Received: from mailhost.nrnet.org (root@mailhost.nrnet.org [166.84.192.39]) by mail1.panix.com (8.8.8/8.8.8/PanixM1.3) with ESMTP id JAA00426 for ; Mon, 12 Jul 1999 09:48:35 -0400 (EDT) Received: from admin.nrnet.org (uucp@localhost) by mailhost.nrnet.org (8.8.7/8.8.4) with UUCP id IAA16045 for pgsql-sql@postgreSQL.org; Mon, 12 Jul 1999 08:45:29 -0400 Received: from localhost (tomg@localhost) by admin.nrnet.org (8.8.7/8.8.7) with SMTP id JAA03231 for ; Mon, 12 Jul 1999 09:50:15 -0400 Date: Mon, 12 Jul 1999 09:50:15 -0400 (EDT) From: Thomas Good To: "PostgreSQL::SQL List" Subject: calculating percentages Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Hi. I am trying to do outcome studies on pt before and after treatment recidivism rates...and having some trouble calculating percentages. How does one do this: SELECT (current_value/target) * 100; in postgres? Cheers - and thanks, Tom ------- North Richmond Community Mental Health Center ------- Thomas Good MIS Coordinator Vital Signs: tomg@ { admin | q8 } .nrnet.org Phone: 718-354-5528 Fax: 718-354-5056 /* Member: Computer Professionals For Social Responsibility */