Re: Efficient deletions?

From: "A(dot)Bhuvaneswaran" <bhuvan(at)symonds(dot)net>
To: Bertrand Petit <pgsql-sql(at)phoe(dot)frmug(dot)org>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Efficient deletions?
Date: 2003-08-02 07:21:06
Message-ID: Pine.LNX.4.44.0308021249450.2159-100000@Bhuvan.bksys.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Toby Tremayne 2003-08-03 10:20:50 Re: join optimization problem
Previous Message Bertrand Petit 2003-08-02 00:21:52 Efficient deletions?