Title: [GENERAL] Postgres plpgsql
Im finding a problem with updating in PGPLSQL
Can anyone find anything wrong with this code below. It appears Postgres isnt picking up a change in the dynamic first column. So the same column is being updated.
.
snip
EXECUTE ''UPDATE TABLENAME SET
Shaun Clements wrote:
Im finding a problem with updating in PGPLSQL
Can anyone find anything wrong with this code below. It appears Postgres
isnt picking up a change in the dynamic first column. So the same column is
being updated.
.
snip
EXECUTE ''UPDATE TABLENAME SET
Title: RE: [GENERAL] Postgres plpgsql
Hi Richard
Thanks for your help.
Im stuck on this statement.
Am I missing the '' ???
snip
PERFORM distinct COLUMN1 FROM TABLE where COLUMN1 = || quote_literal(VARIABLE1)'' ||'' AND COLUMN2 = ||quote_literal(VARIABLE2)||;
IF NOT FOUND
On Mar 30, 2005, at 9:34 AM, Shaun Clements wrote:
PERFORM distinct COLUMN1 FROM TABLE where COLUMN1 = ||
quote_literal(VARIABLE1)'' ||'' AND COLUMN2 =
||quote_literal(VARIABLE2)||;
The first one you posted looked correct. This line above seems to have
problems. I think you want