Re: Add Missing From?

From: Harald Fuchs <hf0722x(at)protecting(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Add Missing From?
Date: 2004-08-10 12:01:00
Message-ID: pu3c2v2oeb.fsf@srv.protecting.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

In article <16580(dot)1092071243(at)sss(dot)pgh(dot)pa(dot)us>,
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

> Jan Wieck <JanWieck(at)Yahoo(dot)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?

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message pgsql 2004-08-10 13:48:49 Re: fsync vs open_sync (more info)
Previous Message Michael Glaesemann 2004-08-10 10:25:32 Regression failure on Mac OS X 10.3.5 (test geometry)