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