From: Thomas Good <tomg@admin.nrnet.org>
To: PostgreSQL::SQL List <pgsql-sql@postgreSQL.org>
Subject: calculating percentages
Date: Mon, 12 Jul 1999 09:50:15 -0400 (EDT)
Message-ID: <Pine.LNX.3.96.990712094714.3092A-100000@admin.nrnet.org> (raw)
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 */
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tomg@admin.nrnet.org
Subject: Re: calculating percentages
In-Reply-To: <Pine.LNX.3.96.990712094714.3092A-100000@admin.nrnet.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox