Hello Everybody!
I´m trying to use delete to
remove data from one table based on another. The query is this:
DELETE FROM table1 WHERE column1
IN (SELECT column2 FROM table2);
but my table is big, so it takes
a lot o time...
Is there a way to use DELETE
with INNER JOIN in PostGreSQL?
Thanks!
Att.
Ricardo Valença UEAD - UGF |
- [ADMIN] delete to slow Ricardo Valença de Assis
- Re: [ADMIN] delete to slow Bruno Wolff III
- Re: [ADMIN] delete to slow Ricardo Valença de Assis
- Re: [ADMIN] delete to slow Jim C. Nasby
- Re: [ADMIN] delete to slow Ricardo Valença de Assis
- Re: [ADMIN] delete to slow Jim C. Nasby
- Re: [ADMIN] delete to ... Tom Lane
- Re: [ADMIN] delete... Jim C. Nasby
- Re: [ADMIN] delete... Tom Lane
- Re: [ADMIN] delete... Jim C. Nasby
- Re: [ADMIN] delete to slow Tom Lane