pivot functions with variable number of columns

From: punnoose <punnoose(dot)pj(at)dwisesolutions(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pivot functions with variable number of columns
Date: 2012-09-06 05:14:33
Message-ID: 1346908473155-5723013.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Travers 2012-09-06 05:34:08 Re: "Too far out of the mainstream"
Previous Message Edson Richter 2012-09-06 04:43:29 Re: "Too far out of the mainstream"