Re: delete to slow

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: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] 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  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 majordomo@postgresql.org)