On Sat, 2005-12-03 at 10:42 +0900, Atsushi Ogawa wrote: > Thanks for comments. I modified the patch.
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