pivot functions with variable number of columns

Поиск
Список
Период
Сортировка
От punnoose
Тема pivot functions with variable number of columns
Дата
Msg-id 1346908473155-5723013.post@n5.nabble.com
обсуждение исходный текст
Ответы 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>)
Список 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.


В списке pgsql-general по дате отправления:

Предыдущее
От: Chris Travers
Дата:
Сообщение: Re: "Too far out of the mainstream"
Следующее
От: Raghavendra
Дата:
Сообщение: Re: pivot functions with variable number of columns