Re: Problem with Crosstab (Concatenate Problem)

> What version of PostgreSQL are you running? The error seems to indicate
> that you don't have the crosstab(text,text) form of the function.
>
> In psql do:
> contrib_regression=# \df crosstab
>                          List of functions
> Schema |   Name   | Result data type | Argument data types |  Type
> --------+----------+------------------+---------------------+--------
> public | crosstab | SETOF record     | text                | normal
> public | crosstab | SETOF record     | text, integer       | normal
> public | crosstab | SETOF record     | text, text          | normal
> (3 rows)
>
> Does it look like this?

Ha, that's a thing! Indeed, it looks like this in my case:


 Schema |   Name   | Result data type | Argument data types |  Type
--------+----------+------------------+---------------------+--------
 public | crosstab | SETOF record     | text, integer       | normal
(1 row)


I am running version 8.4.3, on Mac with Kingchaos libraries. Installed the contrib/crosstab myself afterwards.

What can I do now to include the other functions too? Or is this only with newer versions of Crosstab?

Thanks a lot for your help!

Stef