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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Neil Conway <neilc(at)samurai(dot)com>
Cc: Andrew Dunstan <andrew(at)dunslane(dot)net>, Martijn van Oosterhout <kleptog(at)svana(dot)org>, pgsql-patches(at)postgresql(dot)org
Subject: Re: Allow an alias for the target table in UPDATE/DELETE
Date: 2006-01-22 20:07:25
Message-ID: 21060.1137960445@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

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

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Milen A. Radev 2006-01-23 09:14:03 Re: BUG #2195: log_min_messages crash server when in DEBUG3 to 5
Previous Message Alexey Slynko 2006-01-22 19:57:27 TODO item: locale per database patch (new iteration)