Hello 2012/9/6 Misa Simic <misa.simic@xxxxxxxxx>: > 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.pj@xxxxxxxxxxxxxxxxxx> >> >> 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@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
