On Wed, Sep 5, 2012 at 10:14 PM, punnoose <punnoose.pj@xxxxxxxxxxxxxxxxxx> wrote:
Best Wishes,
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.
You could detect the columns you want to return and use a plpgsql function that returns a refcursor, I suppose.
Best Wishes,
Chris travers
