Calculate a quotient for a count of boolean values (true or false)

Поиск
Список
Период
Сортировка
От Alexander Farber
Тема Calculate a quotient for a count of boolean values (true or false)
Дата
Msg-id CAADeyWi0_DsBtj5oUMT91bdL2=qJqh2Z+QnhJ3ZpX34GQDYghw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Calculate a quotient for a count of boolean values (true or false)  (Alban Hertroys <haramrae@gmail.com>)
Re: Calculate a quotient for a count of boolean values (true or false)  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Список 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 по дате отправления:

Предыдущее
От: Toby Corkindale
Дата:
Сообщение: Re: PSA: If you are running Precise/12.04 upgrade your kernel.
Следующее
От: Alban Hertroys
Дата:
Сообщение: Re: Calculate a quotient for a count of boolean values (true or false)