Return-Path: mao
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA28314; Thu, 18 Mar 93 08:59:33 -0800
Message-Id: <9303181659.AA28314@postgres.Berkeley.EDU>
From: <mao@postgres.berkeley.edu>
Subject: Re: counting combinations (2)
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
In-Reply-To: Your message of Thu, 18 Mar 93 10:51:52 +0700.
             <9303180952.AA26528@postgres.Berkeley.EDU> 
Date: Thu, 18 Mar 93 08:59:46 PST

In message <9303180952.AA26528@postgres.Berkeley.EDU> you write:

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

hi peter,

what you want to do isn't supported in postquel; we don't support
group by or correlated subqueries.
					mike