Have you tried using "group by"? > Hello pgsql listers, > > I've got a problem that is similar to, but I don't think identical to, > a cross tab query. My data looks like: > ID | CAT > 1 | A > 1 | B > 2 | A > 2 | C > So for each ID there may be many CAT (categories). > The client wants it to look like: > ID | CATS > 1 | A,B > 2 | A,C > Where each ID is unique in the results, and the CAT values are > concatenated with a comma separator. > > There are about 100 unique CAT values. They only way I can see to do > it is programatically with a for loop. But before I do that I wanted > to bounce it off the fine minds that inhabit this list. > > Thanks, > Rich > > -- > Richard Greenwood > richard.greenwood@xxxxxxxxx > www.greenwoodmap.com > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
