On Fri, Jul 20, 2012 at 2:27 PM, Thomas Kellerer <spam_ea...@gmx.net> wrote: >>>> Now I was wondering if a DELETE statement could be rewritten with the >>>> same "strategy": >>> >>> Not at the moment. There have been discussions of allowing the same >>> table name to be respecified in USING, but there are complications. >> >> However it works. >> >> DELETE FROM some_table USING some_table AS s >> WHERE >> some_table.col1 = s.col1 AND >> some_table.col2 = s.col2 AND >> some_table.id < s.id; >> > > But that's not an outer join
Oh, yes. I just lost the discussion line. Sorry. -- Sergey Konoplev a database architect, software developer at PostgreSQL-Consulting.com http://www.postgresql-consulting.com Jabber: gray...@gmail.com Skype: gray-hemp Phone: +79160686204 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql