----- Original Message -----
From: <operationsengineer1(at)yahoo(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Sent: Tuesday, May 09, 2006 3:59 PM
Subject: [NOVICE] Math Query Help
> (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?
This should work:
SELECT((select count(inspect_pass) from t_inspect where
inspect_pass = true)/(select count(inspect_pass) from
t_inspect))
Regards,
George