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