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





Mon, 16 Dec 2002 12:8:48 +0800
"Jinqiang Han" <postgresql@db.pku.edu.cn>
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


Sun, 15 Dec 2002 20:25:44 -0800
Joe Conway <mail@joeconway.com>
Re: about table function