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

From Jan Wieck
Subject Re: Add Missing From?
Date
Msg-id 4117AE0A.2090402@Yahoo.com
Whole thread Raw
In response to Re: Add Missing From?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
On 8/9/2004 12:53 PM, Josh Berkus wrote:

> People,
> 
>> >       DELETE FROM target_tbl USING other_tbls WHERE ...
>>
>> Feels much more understandable. The second FROM looks like a hickup.
> 
> Yes, although imagine:
> 
> DELETE FROM staff USING users JOIN logons USING (user_id)
> WHERE last_logon < ( now() - '6 months');
> 
> Not as bad as FROM, but still a bit baffling to look at.   Still, I can't 
> think of anything else that wouldn't require inventing a new reserved word.

What about

DELETE FROM staff JOIN users ...

then?

> 
> Oh, and MySQL's "multi-table deletes":  PLEASE tell me that's not 
> SQL-standard.
> 

Yes, not standard.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #


pgsql-hackers by date:

Previous
From: James William Pye
Date:
Subject: Re: Postgres development model (was Re: CVS comment)
Next
From: Peter Eisentraut
Date:
Subject: Re: Beta Leader?