pardon, correct link http://okbob.blogspot.com/2008/08/using-cursors-for-generating-cross.html pavel 2010/1/13 Pavel Stehule <pavel.stehule@xxxxxxxxx>: > Hello > > 2010/1/12 Daniel Schuchardt <d.schuchardt@xxxxxxxxxxxxx>: >> Hy, >> >> i'm looking for a solution to get this table dynamicaly in that resultset: >> >> SELECT r_dbrid, r_kategorie AS column_name, r_descr AS value FROM >> recnokeyword WHERE r_dbrid=X >> r_dbrid | r_kategorie | r_descr >> ----------+-------------+------------ >> 14725737 |material | Alu Sorte1 >> 14725737 |farbe | Blau >> 14725737 |gewicht | 100 kg >> >> ----> >> >> material | farbe | gewicht >> ----------+-------------+------------ >> alu sorte 1|blau | 100kg >> >> ----> the number of columns depends on data. >> >> is there is a simple solution for that? >> -- > > look on http://okbob.blogspot.com/2008_08_01_archive.html > > Regards > Pavel Stehule > >> >> Daniel Schuchardt >> /Softwareentwicklung/ >> >> /http://www.prodat-sql.de/ >> >> >> -- >> Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general >> > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
