On Sat, 2005-12-03 at 10:42 +0900, Atsushi Ogawa wrote:
> Thanks for comments. I modified the patch.
Advertising
Patch applied to HEAD.
>From looking at SQL2003, it seems to me that this syntax is actually
specified by the standard:
<update statement: searched> ::=
UPDATE <target table> [ [ AS ] <correlation name> ]
SET <set clause list>
[ WHERE <search condition> ]
<delete statement: searched> ::=
DELETE FROM <target table> [ [ AS ] <correlation name> ]
[ WHERE <search condition> ]
I think we ought to support using the alias in the SET clause,
particularly as the standard allows for it (AFAIK).
-Neil
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
