Hello, On Tue, Jun 11, 2013 at 11:59 AM, Alban Hertroys <haramrae@xxxxxxxxx> wrote: > Because you're calculating a - (b/c) instead of (a-b)/c > On 11 June 2013 11:51, Alexander Farber <alexander.farber@xxxxxxxxx> wrote: >> http://stackoverflow.com/questions/17040692/calculate-a-quotient-in-one-table-and-store-it-in-another-table right, sorry! But now I have -1,0,1 only: select id, (count(nullif(nice, false)) - count(nullif(nice, true))) / count(nice) as rating from pref_rep where nice is not null group by id ; id | rating -------------------------+-------- DE10019 | 0 DE10030 | 1 DE10047 | 0 DE10049 | 1 DE10051 | 0 DE10059 | -1 DE10062 | 0 DE10067 | -1 DE10072 | -1 Regards Alex -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
