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
''||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.
You're not wrong there. However, you can use RAISE NOTICE - something like
RAISE NOTICE ''my vars = % / %'',variable1,variable2;
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])