Re: [SQL] More efficient DELETE ... ?

On Sat, 22 Jan 2000, Tom Lane wrote:

> The Hermit Hacker <scrappy@hub.org> writes:
> > This looks painful ...
> 
> > DELETE FROM webhit_referer_raw
> >       WHERE oid IN ( SELECT w.oid
> >                        FROM webhit_referer_raw w, referrer_data r
> >                       WHERE stat_date < 'Jan 17 2000 15:05:00'
> >                         AND w.referrer_url = r.referrer );
> 
> I believe you can do
> 
> DELETE FROM webhit_referer_raw
> WHERE referrer_url = referrer_data.referrer
>       AND referrer_data.stat_date < 'Jan 17 2000 15:05:00';
> 
> (I assume stat_date is in referrer_data, otherwise this'd be easy.)

nope, stat_date is in webhit_referer_raw, but it works like a charm,
thanks :)

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org