Обсуждение: "Inverting" a table, OLAP-style

I have a data-collection app, which creates a table like this, more or less:

t    timestamp
name    varchar
value   numeric

the number of distinct values of <name> is 800 and growing, besides being
data-dependent, so it might be pretty inconvenient to have a single table with
800 columns.  (and we might exceed the 1600-column limit someday)

But clients WOULD like to view the data sometimes as though it were:

t         x                        y                          z  
----------------------------------------------------------------
t1     value when name='x'    value when name='y'       value when name='z'


if they do a SELECT on time=t1 and (name='x' or name='y' or name='z')

This seems like a fairly common desire.  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.  Any ideas on how to do
this?

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