Hey Eric, 2011/3/9 Eric Ndengang <[email protected]>
> 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: [email protected] | 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 ([email protected]) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql > -- // Dmitriy.
