| From: | Thomas Good <tomg(at)nrnet(dot)org> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Thomas Good <tomg(at)admin(dot)nrnet(dot)org>, "PostgreSQL::SQL List" <pgsql-sql(at)postgreSQL(dot)org> |
| Subject: | Re: [SQL] calculating percentages |
| Date: | 1999-07-12 14:50:27 |
| Message-ID: | Pine.LNX.3.96.990712104853.16755A-100000@mailhost.nrnet.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Mon, 12 Jul 1999, Tom Lane wrote:
> Thomas Good <tomg(at)admin(dot)nrnet(dot)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
The divison rtns 0, which multiplied by 100, rtns 0.
It's neat. But not quite the dramatic proof (of the efficacy
of our treatment) that my superiors are looking for!
------- 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 */
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tiberiu Craciun | 1999-07-12 14:53:36 | Re: [SQL] calculating percentages |
| Previous Message | Thomas Good | 1999-07-12 13:50:15 | calculating percentages |