tablefunc extension

Hi Folks,

The following query appears to be correct but fails to execute.

\set VERBOSITY verbose

select * from crosstab('select claim_id::bigint, patient_id::integer, code_id::text from diagnosis') as dg_list(claim_id bigint, patient_id integer, code_id text);

ERROR: 42601: return and sql tuple descriptions are incompatible
LOCATION: crosstab, tablefunc.c:445

The above query works if patient_id is cast to text. The claim_id as bigint works too.

postgres 9.2.4
openSUSE 12.3 (x86_64)
VERSION = 12.3

diagnosis
--------------+--------------+-------------------------------------------------------------------
id | integer | not null default nextval('diagnosis_id_seq'::regclass)
patient_id | integer | not null
code_id | text | not null
claim_id | bigint |
seq_num | smallint |
poa_indicator | character(1) |

Thanks for your time and help.

Carl Clemens

The information transmitted is intended only for the person or entity to which
it is addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of, or taking of any action
in reliance upon, this information by persons or entities other than the
intended recipient is prohibited. If you are not the intended recipient of this
message, please contact the sender and delete this material from this computer.