Hey Eric, 2011/3/9 Eric Ndengang <eric.ndengang_fo...@affinitas.de>
> Hi Guys, > I have the following table: > > Name Value rang salary > ------------------------------------ > name1 value1 1 2500 > name2 value2 2 2600 > name3 value 3 3 300 > > and want to obtain the following result: > > name1 name2 name3 > ------------------------------------ > value1 value2 value3 > 1 2 3 > 2500 2600 300 > > what should i do ? I read about the crosstab function in postgresql but > still have no idea on how to use it to solve this problem. > Any help would be appreciated > Please, see the complete example here: http://www.postgresql.org/docs/9.0/static/tablefunc.html > Regards > > -- > Eric Ndengang > Datenbankadministrator > > Affinitas GmbH | Kohlfurter Straße 41/43 | 10999 Berlin | Germany > email: eric.ndengang_fo...@affinitas.de | tel: +49.(0)30. 991 949 5 0 | > www.edarling.de > > Geschäftsführer: Lukas Brosseder, David Khalil, Kai Rieke, Christian > Vollmann > Eingetragen beim Amtsgericht Berlin, HRB 115958 > > > -- > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql > -- // Dmitriy.
