Subject: counting combinations

From: Peter van Oosterom <[email-masked]>
Date: Sat, 13 Mar 93 13:01:03 MET

Dear Postgres-group,

I want to count combinations of attribute values.
For example in relation X:
   a     b
   3     6
   2     3
   3     8
I would like to obtain the following result Y:
   a     number_of_b
   3     2
   2     1
Is this possible in Postquel?

Kind regards, Peter van Oosterom.