Re: Allow an alias for the target table in UPDATE/DELETE

Neil Conway <neilc(at)samurai(dot)com> writes:
> Did you actually test this?

> neilc=# create table t1 (a int, b int);
> CREATE TABLE
> neilc=# update t1 set set a = 500 where set.a > 1000;
> UPDATE 0

I get

regression=# update t1 set set a = 500 where set.a > 1000;
ERROR: syntax error at or near "a" at character 19
LINE 1: update t1 set set a = 500 where set.a > 1000;
^

I think possibly you put the %nonassoc entry in the wrong place --- it
has to go someplace before the UMINUS entry to get the desired effect.
My fault for putting up a non-context diff.

regards, tom lane