count(boolean)
От | Dan MacNeil |
---|---|
Тема | count(boolean) |
Дата | |
Msg-id | 001d01c1ff3f$d7d86470$b11a9318@prometheus обсуждение исходный текст |
Ответ на | Re: Casting timestamp ("Joel Burton" <joel@joelburton.com>) |
Ответы |
Re: count(boolean)
|
Список | pgsql-sql |
I have a table answers_boolean: question_id | integer | not nullevaluation_id | integer | not nullvalue | boolean | I'd like output in the form: question_id, count_true, count_false ....where count_true is the number of questions answered "true" SELECT question_id AS id, value AS val , count(value) AS cnt FROM answers_boolean GROUP BY question_id,value; gives me:id | val | cnt ----+-----+----- 2 | f | 3 2 | t | 3 3 | f | 2 3 | t | 4 ...which is sorta what I want. I've looked through the docs & archive but haven't found the answer. TIA
В списке pgsql-sql по дате отправления: