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
''||quote_ident(variable1)||''=''||quote_literal(Variable2)||'' where
columnname1 =''||quote_literal(variable3)||'' and columnname2 =
''||quote_literal(variable4)||'' and month = ''''07'''' and year =
''''2004'''''';
</snip>
There is clearly a need for a debugging facility.
Kind Regards,
Shaun Clements