Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] calculating percentages - Mailing list pgsql-sql

From Tom Lane
Subject Re: [SQL] calculating percentages
Date
Msg-id 20270.931792016@sss.pgh.pa.us
Whole thread Raw
In response to calculating percentages  (Thomas Good <tomg@admin.nrnet.org>)
Responses Re: [SQL] calculating percentages  (Thomas Good <tomg@nrnet.org>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: [SQL] Stupid question about default time value
Next
From: Thomas Good
Date:
Subject: Re: [SQL] calculating percentages