From: Robert Treat <xzilla@users.sourceforge.net>
To: Dan Langille <dan@langille.org>
Cc: pgsql-sql@postgresql.org
Subject: Re: DELETE FROM t WHERE EXISTS
Date: 28 Feb 2003 15:36:04 -0500
Message-ID: <1046464564.2038.28.camel@camel> (raw)
In-Reply-To: <3E5F530B.1649.424D34C1@localhost>
References: <3E5F530B.1649.424D34C1@localhost>
delete from clp where commit_date < (select commit_date from clp order
by commit_date offset 99 limit 1);
Robert Treat
On Fri, 2003-02-28 at 12:16, Dan Langille wrote:
> 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/
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: xzilla@users.sourceforge.net, dan@langille.org
Subject: Re: DELETE FROM t WHERE EXISTS
In-Reply-To: <1046464564.2038.28.camel@camel>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox