2010/9/30 Raymond O'Donnell <r...@iol.ie>: > On 30/09/2010 12:17, Ben Carbery wrote: > Googling on "sql swap rows columns" found this: > > http://stackoverflow.com/questions/584232/t-sql-how-to-swap-rows-and-columns > > ...which you'll be able to adapt.
We also have the fantastic crosstab in tablefunc module (see chapter F.36.1.4 for v9.0.0) -- Vincenzo Romano at NotOrAnd Information Technologies Software Hardware Networking Training Support Security -- NON QVIETIS MARIBVS NAVTA PERITVS -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
