Re: How to transform table rows into Colum?

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
>

--
*Rick Albright*
Senior Quantitative Analyst
Web: www.insiderscore.com <https://www.insiderscore.com/>
Email: ralbright(at)insiderscore(dot)com <mailto:ralbright(at)insiderscore(dot)com>