Thread: 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@admin.nrnet.org>
To: PostgreSQL::SQL List <pgsql-sql@postgreSQL.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 */
>
>
>