More efficient DELETE ... ?
От | The Hermit Hacker |
---|---|
Тема | More efficient DELETE ... ? |
Дата | |
Msg-id | Pine.BSF.4.21.0001221316390.79710-100000@thelab.hub.org обсуждение исходный текст |
Ответы |
Re: [SQL] More efficient DELETE ... ?
Re: [SQL] More efficient DELETE ... ? |
Список | pgsql-sql |
This looks painful ... DELETE FROM webhit_referer_raw WHERE oid IN ( SELECT w.oid FROM webhit_referer_raw w, referrer_datar WHERE stat_date < 'Jan 17 2000 15:05:00' AND w.referrer_url = r.referrer); But, reading through the man page, it looks like this about the only way of doing it? Or am I missing something as obvious as the UPDATE I asked about the other day? :( Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
В списке pgsql-sql по дате отправления: