On Mon, 12 Jul 1999, Tom Lane wrote:
> 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
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 */