Math Query Help - Mailing list pgsql-novice

From
Subject Math Query Help
Date
Msg-id 20060509205936.31179.qmail@web33308.mail.mud.yahoo.com
Whole thread Raw
List 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

pgsql-novice by date:

Previous
From:
Date:
Subject: Math Operations - DB or App?
Next
From: George Weaver
Date:
Subject: Re: Math Query Help