Hi folks,

I wanted to delete "old" rows from a table.  These are the rows I 
want to keep:

SELECT * 
FROM clp 
ORDER BY commit_date 
LIMIT 100

So I tried this:

DELETE FROM clp 
WHERE NOT EXISTS (
SELECT * 
FROM clp 
ORDER BY commit_date 
LIMIT 100);

Uhh uhh, nothing deleted.  I don't understand why.

OK, I can do this instead:

DELETE from clp 
where commit_log_id NOT in (
SELECT commit_log_id 
FROM clp 
ORDER BY commit_date 
LIMIT 100);

Can you think of a better way?
-- 
Dan Langille : http://www.langille.org/

Responses

• Re: DELETE FROM t WHERE EXISTS at 2003-02-28 13:28:27 from Tomasz Myrta
• Re: DELETE FROM t WHERE EXISTS at 2003-02-28 19:25:27 from Jakub Ouhrabka
• Re: DELETE FROM t WHERE EXISTS at 2003-02-28 19:30:56 from Jeff Eckermann
• Re: DELETE FROM t WHERE EXISTS at 2003-02-28 20:11:53 from Tom Lane
• Re: DELETE FROM t WHERE EXISTS at 2003-02-28 20:34:45 from Stephan Szabo
• Re: DELETE FROM t WHERE EXISTS at 2003-02-28 20:36:04 from Robert Treat
• Re: DELETE FROM t WHERE EXISTS at 2003-02-28 22:47:04 from Dmitry Tkach

pgsql-sql by date

Next:	From: Guy Fraser	Date: 2003-02-28 17:57:05
	Subject: Re: WebDB, iAS
Previous:	From: Montrone, Marc -- 7183	Date: 2003-02-28 15:26:08
	Subject: Optimizing