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
Regards -- Eric Ndengang Datenbankadministrator Affinitas GmbH | Kohlfurter Straße 41/43 | 10999 Berlin | Germany email: eric.ndengang_foyet@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
pgsql-sql by date:
Соглашаюсь с условиями обработки персональных данных