Neil Conway <[EMAIL PROTECTED]> writes:
> 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> ]
Interesting, because the AS clause is most definitely *not* in
SQL92 or SQL99.
I'm all for this change, in any case, but it's interesting to notice
that the SQL committee actually does respond to the masses ...
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
