=?iso-8859-1?Q?Ricardo_Valen=E7a_de_Assis?= <[EMAIL PROTECTED]> writes:
> DELETE FROM table1 WHERE column1 IN (SELECT column2 FROM table2);
What PG version is this, and what does EXPLAIN say about that query?
> Is there a way to use DELETE with INNER JOIN in PostGreSQL?
You could do "DELETE FROM table1 WHERE column1 = table2.column2" but
that is not necessarily better.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
