Re: Add Missing From?

On 8/9/2004 12:29 AM, Tom Lane wrote:

> Robert Treat <xzilla@users.sourceforge.net> writes:
>> Well, as yall have pointed out, the feature is not sql spec (for some
>> reason I thought it had been put in) so since the update syntax seems
>> quite similar to oracles, perhaps they can provide a pointer on delete
>> syntax as well?  I can't seem to find my oracle syntax book, anyone
>> have one handy ?
> 
> Didn't get any Oracle hits in a quick google, but I did find out that
> MySQL spells it USING:
> 
>     DELETE FROM target_tbl USING other_tbls WHERE ...

Feels much more understandable. The second FROM looks like a hickup.


Jan

> 
> This isn't a particularly compelling precedent seeing that (a) MySQL
> doesn't use our flavor of UPDATE syntax and (b) they only adopted the
> above in 4.0.2.  But it's better than no precedent.  And frankly I
> was having a big problem with "DELETE FROM target FROM others ..."
> If that's not a recipe for confusion I don't know what is.
> 
>             regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match


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