| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2000-01-22 17:56:59 | Re: [SQL] More efficient DELETE ... ? |
| Previous Message | Neil Cameron | 2000-01-22 01:14:27 | SQL Things |