Re: Converting Rows to Columns - Mailing list pgsql-general

From Relyea, Mike
Subject Re: Converting Rows to Columns
Date
Msg-id 1806D1F73FCB7F439F2C842EE0627B180B75D4B7@USA0300MS01.na.xerox.net
Whole thread Raw
In response to Converting Rows to Columns  (Joshua Berry <yoberi@gmail.com>)
List pgsql-general
> -----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

pgsql-general by date:

Previous
From: Ian Barwick
Date:
Subject: Re: Converting Rows to Columns
Next
From: Andreas Kretschmer
Date:
Subject: Re: Converting Rows to Columns