Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

dynamic crosstab


  • From: Florent THOMAS <mailinglist(at)tdeo(dot)fr>
  • To: postgesql general <pgsql-general(at)postgresql(dot)org>
  • Subject: dynamic crosstab
  • Date: Mon, 01 Feb 2010 00:52:46 +0100
  • Message-id: <1264981966.28479.5.camel@Dell_Inspiron> <text/plain>

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


Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group