| From: | Julia Jacobson <julia(dot)jacobson(at)arcor(dot)de> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Crosstab query on huge amount of values |
| Date: | 2011-01-16 22:40:34 |
| Message-ID: | 4D3373E2.1020805@arcor.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello everybody out there using PostgreSQL,
A table with the results of students in different exams
student | date_of_exam | grade
------------------------------
Peter | 2010-09-09 | 2
Tom | 2010-09-09 | 1
Andy | 2010-09-21 | 3
Tom | 2010-09-21 | 4
Peter | 2010-09-21 | 1
Peter | 2010-10-11 | 2
shall be transformed to a denormalized view like:
student | grade_2010_09_09 | grade_2010_09_21 | grade_2010_10_11
----------------------------------------------------------------
Peter | 2 | 1 | 2
Tom | 1 | 4 | NULL
Andy | NULL | 3 | NULL
I've already done extensive Web-search and posted in Usenet for help
concerning this problem and was pointed to the tablefunc module which
seems to be a solution.
Since I only have a database but no administrative rights for the
PostgreSQL installation, I can't use the tablefunc module.
Is there any way to denormalize my table using a simple SQL script?
Thanks in advance,
Julia
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Vondra | 2011-01-16 22:41:39 | Re: How to generate unique invoice numbers for each day |
| Previous Message | Adrian Klaver | 2011-01-16 22:32:19 | Re: Why can't I change a password <SOLVED> |