Обсуждение: 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