Re: Crosstab function - Mailing list pgsql-general

What I have done in the past to build a generic reporting application is to have the function write the results you want in a table and return the tablename and then have the client code call select * from that table.

My standard report tablename is tblreport || userid;
It gets dropped at the beginning of the function, so it is basically a temp table that doesn't interfere with any other users.

Example:
    execute 'drop table if exists reports.tblreport' || v_userid ;
    execute 'drop sequence if exists reports.tblreport' || v_userid || '_id_seq; create sequence reports.tblreport' || v_userid || '_id_seq';
    v_sql=' create table reports.tblreport' || v_userid || ' as ';

Sim