about table function

hello, Joe Conway.

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?
thank you very much

best regard,

Jinqiang Han

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