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?

Ok, got it re-compiled and re-inserted, and now they are there, these functions. Thanks a lot for your help!