Re: Dynamic table with variable number of columns

Thank you very much.
Much appreciated.
NK

----- Original Message -----
From: Bruno Wolff III <bruno@wolff.to>
Date: Friday, July 14, 2006 2:50 pm
Subject: Re: Dynamic table with variable number of columns

> On Wed, Jul 12, 2006 at 13:38:34 -0700,
>  nkunkov@optonline.net wrote:
> > Hi,
> > Thanks again.
> > One more question.  Will crosstab function work if i will not
> know the
> > number/names of columns before hand?  Or I need to supply colum
> > headings?
>
> I checked a bit into this, and the actual contrib name is
> tablefunc, not
> crosstab. It provides crosstab functions for up to 4 columns, but
> it isn't
> hard to make ones that handle more columns.
>
> You can read the included readme file at:
> http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/tablefunc/README.tablefunc?rev=1.14
>