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