From: | Erik Wienhold <ewie(at)ewie(dot)name> |
---|---|
To: | M Sarwar <sarwarmd02(at)outlook(dot)com> |
Cc: | "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: ERROR: return and sql tuple descriptions are incompatible |
Date: | 2024-05-04 23:04:37 |
Message-ID: | vulsb3n6dcd7wzjuhslppt3oij3nkwqh2olagmx2ibtnjzpccu@7c2jvcyjm2x2 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | M Sarwar | 2024-05-05 00:38:34 | Re: ERROR: return and sql tuple descriptions are incompatible |
Previous Message | M Sarwar | 2024-05-04 18:01:51 | ERROR: return and sql tuple descriptions are incompatible |