ridiculously large crosstabs

From: "Joseph Doench" <jdoench(at)cinci(dot)rr(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: ridiculously large crosstabs
Date: 2011-04-06 13:27:00
Message-ID: 001501cbf45e$4fa90050$eefb00f0$@rr.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Thom Brown 2011-04-06 13:38:11 Re: Critical Bug
Previous Message Thom Brown 2011-04-06 12:49:24 Re: forums.postgresql.com.au