| From: | "Relyea, Mike" <Mike(dot)Relyea(at)XEROX(dot)COM> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Cc: | "Joshua Berry" <yoberi(at)gmail(dot)com> |
| Subject: | Re: Converting Rows to Columns |
| Date: | 2009-05-05 14:53:04 |
| Message-ID: | 1806D1F73FCB7F439F2C842EE0627B180B75D4B7@USA0300MS01.na.xerox.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Joshua Berry
> Sent: Tuesday, May 05, 2009 10:39 AM
> To: pgsql-general(at)postgresql(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ian Barwick | 2009-05-05 15:01:38 | Re: Converting Rows to Columns |
| Previous Message | Joshua Berry | 2009-05-05 14:38:44 | Converting Rows to Columns |