Re: DELETE with JOIN - Mailing 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