Re: Error in Update and Set statement

Boss !!

I am using postgres 9.4, so how to handle this.

On Wed, Jan 20, 2016 at 4:11 PM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
wrote:

> Hi
>
> 2016-01-20 11:36 GMT+01:00 Sachin Srivastava <ssr(dot)teleatlas(at)gmail(dot)com>:
>
>> Dear Folks,
>>
>> How to handle the below error, please suggest. I have migrated my
>> database from oracle to postgres through Ora2PG then I am getting this
>> error for function.
>>
>> If I am writing the code for every column which are within set (column
>> name1, column name2, etc) then it's running successfully but if there are
>> so many columns with set then how can I handle this because in below code
>> there are 7 column with set statement and we have to write very big code
>> for this. Please suggest how to handle this situation.
>>
>>
>>
>> ERROR: syntax error at or near "SELECT"
>> LINE 2: ...LEAD_TIME,ITEM_NUMBER,ORDER_UOM_CODE,ORDER_QTY) =(SELECT LIN...
>> ^
>> ********** Error **********
>>
>>
>> ERROR: syntax error at or near "SELECT"
>> SQL state: 42601
>> Character: 123
>>
>> Code as below:
>>
>> -------------------------------
>>
>> update ppo_master_detail set (LINE_STATUS,LINE_TYPE,PROMISE_DATE,
>> LEAD_TIME,ITEM_NUMBER,ORDER_UOM_CODE,ORDER_QTY) =(SELECT
>> LINE_STATUS,
>>
>> LINE_TYPE,PROMISE_DATE,LEAD_TIME,ITEM_NUMBER,ORDER_UOM_CODE,ORDER_QTY
>> from ppo_master_detail where subscriber_id = 65 and
>> row_number=supplierdetail.row_number
>> and po_number=supplierdetail.po_number and
>> company_id=supplierdetail.company_id )
>> where po_number =PONum.po_number and company_id=PONum.company_id
>> and subscriber_id = 65 and row_number=supplierdetail.row_number;
>> --iRowCounter:=iRowCounter+1;
>>
>>
> This Oracle's syntax is supported from 9.5.
>
> Regards
>
> Pavel
>
>
>> --------------------------------------------
>>
>
>