I need to generate a very large crosstab. about 50 rows x 50 columns -- for a request for a recurring report.
Example: Column Headings = Job_ID and Row Headings = Employee_ID and Values in the table = Hours_worked Got the idea? I've looked at : http://www.postgresonline.com/journal/archives/14-CrossTab-Queries-in-Postgr eSQL-using-tablefunc-contrib.html ...and the comments there. Of course, the Job_IDs change every month... I need some more clues on how to proceed with this - how to 'get' and output the column headings? (Using pgsql 8.2) Thanks, JPD -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
