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

Re: DELETE with LIMIT (or my first hack)

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Csaba Nagy <ncslists(at)googlemail(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Jaime Casanova <jaime(at)2ndquadrant(dot)com>, Daniel Loureiro <loureirorg(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: DELETE with LIMIT (or my first hack)
Date: 2010-11-30 15:14:21
Message-ID: (view raw or whole thread)
Lists: pgsql-hackers

On 11/30/2010 09:57 AM, Csaba Nagy wrote:
> So it is really an ideological thing and not lack of demand or
> implementation attempts... I for myself can't write working C code
> anyway, so I got my peace with the workaround - I wish you good luck
> arguing Tom :-)

We need a convincing use case for it. So far the only one that's seemed 
at all convincing to me is the one about deleting in batches. But that 
might be enough.

As for it being illogical, I don't think it's any more so than

    DELETE FROM foo WHERE random() < 0.1;

and you can do that today.



In response to


pgsql-hackers by date

Next:From: Heikki LinnakangasDate: 2010-11-30 15:26:27
Subject: Re: GiST insert algorithm rewrite
Previous:From: Tom LaneDate: 2010-11-30 15:04:20
Subject: Re: DELETE with LIMIT (or my first hack)

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