Skip site navigation (1) Skip section navigation (2)

More efficient DELETE ... ?

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: More efficient DELETE ... ?
Date: 2000-01-22 17:20:06
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
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 );

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 @ 
primary: scrappy(at)hub(dot)org           secondary: scrappy(at){freebsd|postgresql}.org 


pgsql-sql by date

Next:From: Bruce MomjianDate: 2000-01-22 17:56:59
Subject: Re: [SQL] More efficient DELETE ... ?
Previous:From: Neil CameronDate: 2000-01-22 01:14:27
Subject: SQL Things

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group