> -----Original Message----- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
