> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Joshua Berry
> Sent: Tuesday, May 05, 2009 10:39 AM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Converting Rows to Columns
>
> Greetings all,
>
> I know that this is an elementary question, so I'm just
> asking for a pointer in the right direction.
>
> I have a query like this that tries to link Retail shops
> (from the table aliased as 'a') to sales reps (from the table
> aliased as 'e') that service the given Retail shop:
> [snip]
Is a crosstab query what you're looking for?
Mike