howto delete using a join ?

Поиск
Список
Период
Сортировка
От Andreas
Тема howto delete using a join ?
Дата
Msg-id 4C4A66A5.9070609@gmx.net
обсуждение исходный текст
Ответы Re: howto delete using a join ?  (Dmitriy Igrishin <dmitigr@gmail.com>)
Re: howto delete using a join ?  (Joshua Tolley <eggyknap@gmail.com>)
Список pgsql-sql
  Hi,

is there a way to delete from a table using information from another 
table to decide if a row should be dropped?

In my case there is a log
events  ( event_id, event_type_fk, ...);
event_types ( event_type_id, relevance_level );

Now I'd like to delete all old events with certain relevance_levels but 
not all!

This works:
delete from events where event_id in
(    select event_id from events join event_types on event_type_id = 
event_type_fk    where relevance_level in ( 1, 3, 5, 7) and create_ts < '2010/01/01'
);

The following doesn't work but is there a more direct way which doesn't 
involve a subselect?

delete from events join event_types on event_type_id = event_type_fk 
where relevance_level in ( 1, 3, 5, 7);


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

Предыдущее
От: Torsten Zühlsdorff
Дата:
Сообщение: [TRIGGER] Returning values from BEFORE UPDATE trigger, without using them
Следующее
От: Dmitriy Igrishin
Дата:
Сообщение: Re: howto delete using a join ?