Re: [HACKERS] Table aliases in delete statements?

Keith Parks <emkxp01(at)mtcc(dot)demon(dot)co(dot)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