Thanks Sim, a very usefull information.
From: pgsql-general-owner@xxxxxxxxxxxxxx
[mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Sim Zacks
Sent: Wednesday, May 07, 2014 7:33 PM
To: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: [GENERAL] Crosstab function
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
