Hi Pavel, Hm... To me workaround looks as exactly as the same thing?
1) uses Dynamic SQL to bulid query (but returns refcursor insted of text) 2) client still needs to execute 2 commands (second is fetch instead of execute 'result') However, based on your name, and the name of the blog author :) I have made conlusion you are working on Stored Procedures things? I have a few questions about that... But will send another mail to dont mix subjects... Cheers, Misa On Thursday, September 6, 2012, Pavel Stehule wrote: > Hello > > 2012/9/6 Misa Simic <misa.si...@gmail.com <javascript:;>>: > > That is one of most wanted features of PostgreSQL, what is not solved > yet,,, > > > > But it seems will be soon with introductions of Stored Procedures... > > > > I wish :) > > > For now, you must "know" what result (columns) you expects... > > > > So the only one option for now is to use Dynamic SQL - to build your > query > > dynamically based on data in your table (based on column what should be > > pivoted).. > > > > And then execute that query... > > > > You can use your client side language to build SQL or inisde DB you could > > make function what returns "text" as your Dynamic SQL and then execute it > > from your client... > > > > there is a some workaround > > http://okbob.blogspot.cz/2008/08/using-cursors-for-generating-cross.html > > Pavel > > > Kind Regards, > > > > Misa > > > > 2012/9/6 punnoose <punnoose...@dwisesolutions.com <javascript:;>> > >> > >> I want to have a pivot like function in which i should have variable > >> number > >> of columns.i went for crosstab but it doesnot support variable number of > >> columns.Can any body suggest an alternative.like if i have a event at a > >> particular time of the day like one at 02:35,11:34, then i should have > >> column name 02:35,11:34. > >> Please do help me. > >> Punnoose > >> > >> > >> > >> > >> -- > >> View this message in context: > >> > http://postgresql.1045698.n5.nabble.com/pivot-functions-with-variable-number-of-columns-tp5723013.html > >> Sent from the PostgreSQL - general mailing list archive at Nabble.com. > >> > >> > >> -- > >> Sent via pgsql-general mailing list > >> (pgsql-general@postgresql.org<javascript:;> > ) > >> To make changes to your subscription: > >> http://www.postgresql.org/mailpref/pgsql-general > > > > >
