Re: Delete with join -- deleting related table entries?

Поиск
Список
Период
Сортировка
От Owen Jacobson
Тема Re: Delete with join -- deleting related table entries?
Дата
Msg-id 144D12D7DD4EC04F99241498BB4EEDCC20CC5A@nelson.osl.com
обсуждение исходный текст
Ответ на Delete with join -- deleting related table entries?  (Bryce Nesbitt <bryce1@obviously.com>)
Список pgsql-sql
Owen Jacobson wrote:

> BEGIN;
>   DELETE FROM note WHERE issue_id IN (SELECT issue_id FROM isuse
>     WHERE reservation_id = reservation_to_delete);
>   DELETE FROM isuse WHERE reservation_id = reservation_to_delete;
>   DELETE FROM reservations WHERE reservation_id =
> reservation_to_delete;
> END;

That should be COMMIT;, not END;.  Been writing too much pl/pgsql.
-Owen


В списке pgsql-sql по дате отправления:

Предыдущее
От: Bryce Nesbitt
Дата:
Сообщение: Re: Delete with join -- deleting related table entries?
Следующее
От: "BigSmoke"
Дата:
Сообщение: Re: regarding debugging?