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, c=
ode_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 bigin=
t works too.
postgres 9.2.4
openSUSE 12.3 (x86_64)
VERSION =3D 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 wh=
ich
it is addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of, or taking of any act=
ion
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 compu=
ter.