Re: about table function

Jinqiang Han wrote:
> it seems the crosstab function you write in contrib/tablefunc can't work.
> it saids that  A column definition list is required for functions returning RECORD.
> How can i make it work?

From contrib/tablefunc/README.tablefunc:

Outputs
 Returns setof record, which must defined with a column definition in the FROM clause of the SELECT statement, e.g.:
   SELECT *   FROM crosstab(sql, 2)   AS ct(row_name text, category_1 text, category_2 text);
   the example crosstab function produces a set something like:                     <== values  columns ==>
row_name  category_1   category_2          ---------+------------+------------            row1        val1         val2
          row2        val5         val6
 


You are apparently forgetting the "AS ct(row_name text, category_1 text, category_2 text)"
part.

hope this helps,

Joe