On Wed, Sep 5, 2012 at 10:14 PM, punnoose <punnoose(dot)pj(at)dwisesolutions(dot)com>wrote:
> 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