Keith Parks <emkxp01@mtcc.demon.co.uk> writes:
> Is there any reason for not allowing table aliases in
> delete statements?
Not much, I suppose, but it's not in SQL92:
<delete statement: searched> ::= DELETE FROM <table name> [ WHERE <search condition>
]
The expansion of <table name> doesn't mention anything about aliases.
As Bruce points out in another followup, there's no real need for
an alias for the target table; if you have sub-selects that need
independent references to the target, you can always alias *them*.
The same goes for INSERT and UPDATE, which also take unadorned
<table name> as the target table specification.
regards, tom lane