Postgres Pro
Downloads
Home   >   mailing lists

Re: pivot functions with variable number of columns - Mailing list pgsql-general

From Misa Simic
Subject Re: pivot functions with variable number of columns
Date
Msg-id CAH3i69kyvE09SH42Vh+-UxTmWCJ1tiSC=eLg55m7U6WyLrHo3g@mail.gmail.com
Whole thread Raw
In response to pivot functions with variable number of columns  (punnoose <punnoose.pj@dwisesolutions.com>)
Responses Re: pivot functions with variable number of columns
List pgsql-general
Tree view
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...

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...
 
Kind Regards,

Misa

2012/9/6 punnoose <punnoose.pj@dwisesolutions.com>
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)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: return text from explain
Next
From: John R Pierce
Date:
Subject: Re: Moving several databases into one database with several schemas