Re: DELETE with JOIN

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: DELETE with JOIN
Дата
Msg-id 26509.1218139131@sss.pgh.pa.us
обсуждение исходный текст
Ответ на DELETE with JOIN  (felix@crowfix.com)
Ответы Re: DELETE with JOIN  (felix@crowfix.com)
Список 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 по дате отправления:

Предыдущее
От: felix@crowfix.com
Дата:
Сообщение: Re: DELETE with JOIN
Следующее
От: Frank Bax
Дата:
Сообщение: Re: DELETE with JOIN