Catching up on my email. Would it be possible to perform a DELETE FROM table WHERE CURRENT OF mycursor? Is this implemented in Postgres? I'm not seeing in in the manual for 7.4 or 8.
Greg -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruno Wolff III Sent: Wednesday, April 06, 2005 1:32 PM To: Ricardo Valença de Assis Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] delete to slow On Wed, Apr 06, 2005 at 13:45:13 -0300, Ricardo Valença de Assis <[EMAIL PROTECTED]> wrote: > 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? Yes. You should be able to do something like: DELETE FROM table1 WHERE column1 = table2.column2; ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
