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 4: Have you searched our list archives? http://archives.postgresql.org
