Matthew Peter <[EMAIL PROTECTED]> writes:
> it's in a loop so there's an extra comma at the end so i was thinking i
> could put in a throw away value to keep the update from breaking if there's
> an additional comma
The best thing is to fix your loop logic. Usually it's not hard to emit
a comma only if one is needed.
If you're intent on using a broken loop, you could do "foo = foo" where
foo is any table column you didn't yet assign to. Consider though the
corner case where you've already assigned all the columns. Best bet
is to fix your loop...
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
