"Daniel Caune" <daniel(dot)caune(at)ubisoft(dot)com> 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