Re: [HACKERS] Table aliases in delete statements?

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