>> 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! -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
