Postgres Pro
Downloads
Home   >   mailing lists

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

From punnoose
Subject pivot functions with variable number of columns
Date
Msg-id 1346908473155-5723013.post@n5.nabble.com
Whole thread Raw
Responses Re: pivot functions with variable number of columns  (Raghavendra <raghavendra.rao@enterprisedb.com>)
Re: pivot functions with variable number of columns  (Chris Travers <chris.travers@gmail.com>)
Re: pivot functions with variable number of columns  (Misa Simic <misa.simic@gmail.com>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Chris Travers
Date:
Subject: Re: "Too far out of the mainstream"
Next
From: Raghavendra
Date:
Subject: Re: pivot functions with variable number of columns