Message-ID: <001d01c1ff3f$d7d86470$b11a9318@prometheus>
From: "Dan MacNeil" <dan@ltc.org>
To: "pgsql-sql" <pgsql-sql@postgresql.org>
References: <JGEPJNMCKODMDHGOBKDNAELLCOAA.joel@joelburton.com>
Subject: count(boolean) 
Date: Sun, 19 May 2002 10:16:47 -0400
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

I have a table answers_boolean:

 question_id   | integer   | not null
 evaluation_id | integer   | not null
 value             | 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