Re: DELETE with JOIN - Mailing list pgsql-sql

From Tom Lane
Subject Re: DELETE with JOIN
Date
Msg-id 26509.1218139131@sss.pgh.pa.us
Whole thread Raw
In response to DELETE with JOIN  (felix@crowfix.com)
Responses Re: DELETE with JOIN
List pgsql-sql
felix@crowfix.com writes:
> I have tried to do this before and always found a way, usually

>     DELETE FROM a WHERE a.b_id IN (SELECT id FROM b WHERE second_id = ?)

> but I have too many rows, millions, in the IN crowd, ha ha, and it
> barfs.

Define "barfs".  That seems like the standard way to do it, and it
should work.
        regards, tom lane


pgsql-sql by date:

Previous
From: felix@crowfix.com
Date:
Subject: Re: DELETE with JOIN
Next
From: Frank Bax
Date:
Subject: Re: DELETE with JOIN