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

Harald Fuchs <hf0722x@protecting.net> writes:
> Actually, MySQL supports two different syntaxes for multi-table DELETEs:

> 1. DELETE t1,t2 FROM t1,t2,t3 WHERE t1.id=t2.id AND t2.id=t3.id;
>    (introduced in MySQL 4.0.0)

> 2. DELETE FROM t1,t2 USING t1,t2,t3 WHERE t1.id=t2.id AND t2.id=t3.id;
>    (introduced in MySQL 4.0.2)

Yeah.  I ignored the first, as being so stupid that even the MySQL guys
soon realized what a bad idea it was ;-)
        regards, tom lane