| From: | Eric Ndengang <eric(dot)ndengang_foyet(at)affinitas(dot)de> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | How to transform table rows into Colum? |
| Date: | 2011-03-09 17:16:44 |
| Message-ID: | 4D77B5FC.6010502@affinitas.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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(dot)ndengang_foyet(at)affinitas(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dmitriy Igrishin | 2011-03-09 18:07:53 | Re: How to transform table rows into Colum? |
| Previous Message | Ross J. Reedstrom | 2011-03-07 22:32:41 | Re: A function to count all ocurrences of a character within a string. |