Re: Add Missing From? - Mailing list pgsql-hackers

From Harald Fuchs
Subject Re: Add Missing From?
Date
Msg-id pu3c2v2oeb.fsf@srv.protecting.net
Whole thread Raw
In response to Add Missing From?  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Add Missing From?
Re: Add Missing From?
Re: Add Missing From?
List pgsql-hackers
In article <16580.1092071243@sss.pgh.pa.us>,
Tom Lane <tgl@sss.pgh.pa.us> writes:

> Jan Wieck <JanWieck@Yahoo.com> writes:
>> What about
>> DELETE FROM staff JOIN users ...
>> then?

> I don't much care for that, mainly because in my mind "x JOIN y" should
> always be semantically equivalent to "y JOIN x".  I think we want a real
> clear syntactical separation between the deletion target table and the
> other tables.

Just one minor nit:

You're talking about "the deletion target table".  Sorry to mention
the M word again, but MySQL allows deleting from more than one table
at the same time.  Should we support that?



pgsql-hackers by date:

Previous
From: Adam Witney
Date:
Subject: 8.0.0beta1 initdb failure on OSX 10.3.5
Next
From: pgsql@mohawksoft.com
Date:
Subject: Re: fsync vs open_sync (more info)