|
Hi Erik,
TEST1P1 data is coming from the category column,
TESTC.TEST_NUMBER.
TRESULT.TEST_RESULT column is giving value data.
As
I stated in my first email which has results of '\d bronx.TEST_RESULTS_ALL_MCM_INIt' and '\d bronx.TEST_TEST_DETAILS_ALL_MCM_INIT', columns
TESTC.TEST_NUMBER and
TRESULT.TEST_RESULT
data types are
numeric
and character(10) .
This is as per table definitions.
Are you suggesting me to use the type either TEXT or some other data type in the below clause of the SQL.
> ) as ConcatenatedResults (
> SERIALNUMBER character varying ,
> TEST1P1 character
> -- TEST_RESULT numeric
>
Thanks,
Sarwar
From: Erik Wienhold <ewie@xxxxxxxxx>
Sent: Saturday, May 4, 2024 7:04 PM To: M Sarwar <sarwarmd02@xxxxxxxxxxx> Cc: pgsql-admin@xxxxxxxxxxxxxxxxxxxx <pgsql-admin@xxxxxxxxxxxxxxxxxxxx> Subject: Re: ERROR: return and sql tuple descriptions are incompatible On 2024-05-04 20:01 +0200, M Sarwar wrote:
> SELECT * > > FROM CROSSTAB ( > > ' > > SELECT > > PART.SERIAL_NUMBER, > > TESTC.TEST_NUMBER, > > TRESULT.TEST_RESULT > > FROM bronx.TEST_PART_DETAILS_ALL_MCM_INIT PART, > > bronx.TEST_RESULTS_ALL_MCM_INIT TRESULT, > > bronx.TEST_TEST_DETAILS_ALL_MCM_INIT TESTC > > WHERE PART.TEST_PART_DET_ALL_MCM_ID = TRESULT.TEST_PART_DETAILS_ALL_MCM_ID > > AND TRESULT.TEST_TEST_DETAILS_ALL_MCM_ID = TESTC.TEST_TEST_DETAILS_ALL_MCM_ID > > and PART.STAGE = ''FT'' > > AND SPLIT_PART (SERIAL_NUMBER, '':'', 1 ) = ''B7307631'' > > And TESTC.TEST_NUMBER = ''TEST1P1'' > > ORDER BY PART.SERIAL_NUMBER , TESTC.TEST_NUMBER > > ' > > ) as ConcatenatedResults ( > > SERIALNUMBER character varying , > > TEST1P1 character > > -- TEST_RESULT numeric > > ); > > > > Error Encountered: > > ERROR: return and sql tuple descriptions are incompatible SQL state: 42601 The output value columns (TEST1P1 and TEST_RESULT) must be of the same type. And it must be the same type as the third result column (TRESULT.TEST_RESULT). -- Erik |
