Re: Add Missing From?

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

> Robert Treat <xzilla(at)users(dot)sourceforge(dot)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(at)Yahoo(dot)com #