Thread: questions on crosstab/coss-referenced queries
hi list, i have a table that is laid out like this: student_id | tally | org_id --------------+------------------ 1 | 0 | 1 2 | 0 | 1 3 | 0 | 1 4 | 0 | 1 5 | 0 | 1 1 |8367220 | 2 3 |7561391 | 2 5 |2207271 | 2 4 |1280995 | 2 2 |1265355 | 2 and i want to lay the table like this: student_id | 1 | 2 --------------+--------+-------- 1 | 0 | 8367220 2 | 0 | 1265355 3 | 0 | 7561391 4 | 0 | 1280995 5 | 0 | 2207271 does postgres got a tool for queries like cross referencing/ crosstabs? thanks, percy
percy wrote: > does postgres got a tool for queries like cross referencing/ > crosstabs? Yes, it's in the contrib package. e.g with debian: apt-get install postgresql-contrib HTH -- e-Trolley Sayegh & John, Nabil Sayegh Tel.: 0700 etrolley /// 0700 38765539 Fax.: +49 69 8299381-8 PGP : http://www.e-trolley.de