Re: DELETE syntax on JOINS

Tom Lane wrote:
> Robert Haas <robertmhaas@gmail.com> writes:
>   
>> On Mon, Aug 24, 2009 at 9:31 PM, Josh Berkus<josh@agliodbs.com> wrote:
>>     
>>> What I don't get is why this is such a usability issue.  Subqueries in
>>> DELETE FROM work perfectly well, and provide more flexibility than most
>>> users know what to do with.
>>>       
>
>   
>> It's both a usability issue and a performance issue.
>>     
>
> On the usability front: if we were to take the position Josh advocates,
> we should never have added FROM/USING to UPDATE/DELETE at all 


FWIW, I use update ... from  a lot - it make many update queries easier 
and less error prone to write -  but I rarely find I need delete ... using.


> ... but
> since we did, I think we should try to make it as flexible as the
> corresponding feature in other DBMSes.
>
>
>   

+1

cheers

andrew