Re: [SQL] calculating percentages

There is an example :

create table values ( value float ) ;
create function sum_val() returns float as '
select sum(value) as return from values;
' language 'sql';
..........
select (value/sum_val())*100 as percent from values;

if value is integer than

create table values ( value int2 ) ;
create function sum_val() returns int2 as '
select sum(value) as return from values;
' language 'sql';
..........
select (value::float/sum_val()::float)*100 as percent from values;

-----Original Message-----
From: Thomas Good <tomg(at)admin(dot)nrnet(dot)org>
To: PostgreSQL::SQL List <pgsql-sql(at)postgreSQL(dot)org>
Date: lundi 12 juillet 1999 22:31
Subject: [SQL] calculating percentages

>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 */
>
>
>