Thank you very much. Much appreciated. NK ----- Original Message ----- From: Bruno Wolff III <[EMAIL PROTECTED]> 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, > [EMAIL PROTECTED] 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 > ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
