Calculate a quotient for a count of boolean values (true or false) - Mailing list pgsql-general

From Alexander Farber
Subject Calculate a quotient for a count of boolean values (true or false)
Date
Msg-id CAADeyWi0_DsBtj5oUMT91bdL2=qJqh2Z+QnhJ3ZpX34GQDYghw@mail.gmail.com
Whole thread Raw
Responses Re: Calculate a quotient for a count of boolean values (true or false)
Re: Calculate a quotient for a count of boolean values (true or false)
List pgsql-general
Hello!

In a PostgreSQL 8.4.13 why doesn't this please
deliver a floating value (a quotient between 0 and 1):

 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
-------------------------+--------
 DE10072                 |     -1
 DE10086                 |     18
 DE10087                 |      1
 DE10088                 |     -1
 DE10095                 |    276
 DE10097                 |     37
 DE10105                 |      5

I am trying to calculate a sum of ratings
given by users to each other
to draw a pie chart in a game, more details here:

http://stackoverflow.com/questions/17040692/calculate-a-quotient-in-one-table-and-store-it-in-another-table

Thank you


pgsql-general by date:

Previous
From: Toby Corkindale
Date:
Subject: Re: PSA: If you are running Precise/12.04 upgrade your kernel.
Next
From: Alban Hertroys
Date:
Subject: Re: Calculate a quotient for a count of boolean values (true or false)