Neil Conway <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
