Postgres Pro
Downloads
Home   >   mailing lists

Re: Efficient deletions? - Mailing list pgsql-sql

From A.Bhuvaneswaran
Subject Re: Efficient deletions?
Date
Msg-id Pine.LNX.4.44.0308021249450.2159-100000@Bhuvan.bksys.co.in
Whole thread Raw
In response to Efficient deletions?  (Bertrand Petit <pgsql-sql@phoe.frmug.org>)
List pgsql-sql
Tree view 
>     DELETE FROM foo WHERE (col1, col2) IN (SELECT...)

DELETE FROM foo WHERE col1 = sub_select_table.col1 and col2 = 
sub_select_table.col2;

regards,
bhuvaneswaran

pgsql-sql by date:

Previous
From: Bertrand Petit
Date:
Subject: Efficient deletions?
Next
From: Rod Taylor
Date:
Subject: Re: join optimization problem