-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/22/2013 04:17 PM, Joe Conway wrote:
> If you still have a problem please provide SQL that can be cut and
> pasted which: 1) create your table 2) insert sample rows Then show
> us what out put you are trying to acheive as output from that
> data.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/19/2013 12:24 PM, Carl Clemens wrote:
> The following query appears to be correct but fails to execute.
Your example is incorrect, however it is not clear (to me at least)
from your example what you are expecting as output -- please see the
docu
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 tu
