Indeed there is an id field. That's the ticket! And thanks much. -----Original Message----- From: Adrian Klaver [mailto:adrian.klaver@xxxxxxxxx] Sent: Tuesday, February 28, 2012 12:48 PM To: pgsql-general@xxxxxxxxxxxxxx Cc: Lummis, Patrick J; Bartosz Dmytrak Subject: Re: Stored Procedure Record Updates using For Loops - Postgres 8.1 On Tuesday, February 28, 2012 12:35:58 pm Lummis, Patrick J wrote: > Hi Bartek, > > Thanks for the quick response. > > Syntax error cleared up and loads fine but executing the stored > procedure fails to update the row. >From the usage I guessing this function is not being used in a trigger. As such the ROW variable exists outside the table. If you want to UPDATE the table you are going to have to do a hybrid of what you have: update workorder set wfstatus='failed' where id=workorderRecord.id assuming there is an 'id' field of some sort. > > Regards, > > Patrick -- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
