Error in Update and Set statement

From: Sachin Srivastava <ssr(dot)teleatlas(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Error in Update and Set statement
Date: 2016-01-20 10:36:28
Message-ID: CAFzqEh+dtY+ZYPp3hr_iE9PmEsmXpXjt7A8wSybR+7VwQLUZmw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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;

--------------------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dorian Hoxha 2016-01-20 10:37:34 Re: JSONB performance enhancement for 9.6
Previous Message Oleg Bartunov 2016-01-20 08:32:36 Re: JSONB performance enhancement for 9.6