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: Pine.BSF.4.21.0001221316390.79710-100000@thelab.hub.org (view raw or flat)
Thread:
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 @ hub.org 
primary: scrappy(at)hub(dot)org           secondary: scrappy(at){freebsd|postgresql}.org 


Responses

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-2014 The PostgreSQL Global Development Group