Math Query Help

From: <operationsengineer1(at)yahoo(dot)com>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Math Query Help
Date: 2006-05-09 20:59:36
Message-ID: 20060509205936.31179.qmail@web33308.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

i'm trying to work out some match queries to find
yields.

this is what i want to do...

yield = pass / total:

(select count(inspect_pass) from t_inspect where
inspect_pass = true)/(select count(inspect_pass) from
t_inspect)

i get the following error:

ERROR: syntax error at or near "/" at character 70

how can i fix this?

tia...

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message George Weaver 2006-05-09 21:23:38 Re: Math Query Help
Previous Message operationsengineer1 2006-05-09 19:44:49 Math Operations - DB or App?