Re: "Inverting" a table, OLAP-style - Mailing list pgsql-sql

From Tom Lane
Subject Re: "Inverting" a table, OLAP-style
Date
Msg-id 27213.1032188132@sss.pgh.pa.us
Whole thread Raw
In response to "Inverting" a table, OLAP-style  (pacquet@newsguy.com)
List pgsql-sql
pacquet@newsguy.com writes:
> ... I know we could use Pivot Tables in
> Excel, or otherwise do it on the client, but the highest-leverage solution
> would be to present this abstraction in the server.

Joe Conway's contrib/tablefunc module (new for 7.3) has a "crosstab"
facility that I think might do what you want.  Perhaps you'd like to
snag a 7.3 beta copy and try it out.
        regards, tom lane


pgsql-sql by date:

Previous
From: "Ries van Twisk"
Date:
Subject: Dublicates pairs in a table.
Next
From: Stephan Szabo
Date:
Subject: Re: does table names have a format and size