Josh Berkus wrote: > All, > > >> DELETE FROM target t USING t LEFT JOIN other_table ot ON ... > >> > >> but we have always considered that the target is *not* to be identified > >> with any member of the FROM/USING clause, so it would be a serious > >> compatibility break to change that now. > > What I don't get is why this is such a usability issue. Subqueries in > DELETE FROM work perfectly well, and provide more flexibility than most > users know what to do with.
OK, so you are saying that every OUTER join can be efficiently reprsented as a subquery? If that is true we don't need to add ANSI join support to USING. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
