dynamic crosstab

From: Florent THOMAS <mailinglist(at)tdeo(dot)fr>
To: postgesql general <pgsql-general(at)postgresql(dot)org>
Subject: dynamic crosstab
Date: 2010-01-31 23:52:46
Message-ID: 1264981966.28479.5.camel@Dell_Inspiron
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello everybody,

I'm trying to find out how to have a dynamic crosstab as in excel,
ireport,etc...
As i understand of the manual here :
http://docs.postgresqlfr.org/8.4/tablefunc.html
I can have multiple columns.

Unfortunately, it seems indispensible to name the columns in the AS
clause.
Am I right or is ther a way to let the query generate the columns and
there name without naming them?

Best regards

Florent THOMAS

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Florent THOMAS 2010-01-31 23:53:07 problem with triggers
Previous Message zhong ming wu 2010-01-31 21:35:20 Re: back out configure options