If you want to use the boolean approach I would just (as suggested earlier) cast to integer and sum. Like: SELECT sum(good::int) as good, count(good)-sum(good::int) as "not good"
and so on I thing the boolean approach seems reasonable if good, nice and fair is three separaty judgements as I understand they are. Regards Nicklas ----- Original message ----- > Thank you all, I've ended up with the following. > > But I really wonder if using boolean in my case > (trying to offer players a web from with 3 x 2 radio buttons > to rate each other) is really the best choice - > since it feels a bit awkward (and maybe slow?) > > # create table pref_rep ( > id varchar(32) references pref_users(id) >check (id != > author), author varchar(32) references > pref_users(id), > good boolean, > fair boolean, > nice boolean, > about varchar(256), > last_rated timestamp default current_timestamp > ); > > # select * from pref_rep ; > id | author | good | fair | nice | about | >last_rated > --------+--------+------+------+------+-----------+---------------------------- > DE7085 | DE7317 | t | t | t | comment 1 | 2010-11-16 > 20:26:04.780827 DE7085 | DE7336 | t | | t | comment 1 | > 2010-11-16 20:26:14.510118 DE7085 | DE7641 | t | f | t | > comment 2 | 2010-11-16 20:26:29.574055 DE7085 | DE7527 | f | f | t > | comment 3 | 2010-11-16 20:26:45.211207 DE7085 | DE7184 | f | f > > | f | comment 3 | 2010-11-16 20:26:56.30616 (5 rows) > > # select > sum(case when good then 1 else 0 end) as good, > sum(case when not good then 1 else 0 end) as "not good", > sum(case when fair then 1 else 0 end) as fair, > sum(case when not fair then 1 else 0 end) as "not fair", > sum(case when nice then 1 else 0 end) as nice, > sum(case when not nice then 1 else 0 end) as "not nice" > from public.pref_rep; > > good | not good | fair | not fair | nice | not nice > ------+----------+------+----------+------+---------- > 3 | 2 | 1 | 3 | 4 | > 1 > (1 row) > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
