you can also generate a crosstab table using the sign function
you can check out the link below ( its a sqlite tutorial, but the same idea will work for pg too )
http://souptonuts.sourceforge.net/readme_sqlite_tutorial.html On 03/09/2011 12:16 PM, Eric Ndengang wrote:
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
