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

Reply via email to