Re: [SQL] Problem with committing the update

2012-09-22 Thread Jasen Betts
On 2012-09-13, BeeBee wrote: > Hi all, > > I have a problem updating the record using store procedure (LANGUAGE > plpgsql).I have attach the query. it all looks good to me. -- ⚂⚃ 100% natural -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription

[SQL] Problem with committing the update

2012-09-14 Thread BeeBee
Hi all, I have a problem updating the record using store procedure (LANGUAGE plpgsql).I have attach the query. http://postgresql.1045698.n5.nabble.com/file/n5723831/query.txt query.txt /SELECT id INTO STRICT temp_id from T_table_B where T_table_B.column_id = $1 and T_table_B.status = 'False';