"Daniel Caune" <[EMAIL PROTECTED]> writes:
> CREATE OR REPLACE FUNCTION foo(i IN int)
> RETURNS void
> AS $$
> BEGIN
> UPDATE bar
> SET i = i; // column i = parameter i
> END;
> $$ LANGUAGE PLPGSQL;
In SELECTs you can qualify the column, ie, bar.i vs i. That doesn't
work for an UPDATE target, though, so probably the best answer is
"don't do that". I think it's entirely too error-prone anyway ...
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
