Re: [HACKERS] [pgadmin-hackers] Feature request: limited deletions

2010-04-08 Thread Csaba Nagy
Hi all, On Thu, 2010-04-08 at 07:45 -0400, Robert Haas wrote: > >> 2010/4/8 Thom Brown : > >> > So you could write: > >> > > >> > DELETE FROM massive_table WHERE id < 4000 LIMIT 1; > I've certainly worked around the lack of this syntax more than once. > And I bet it's not even that hard t

Re: [HACKERS] [pgadmin-hackers] Feature request: limited deletions

2010-04-08 Thread Robert Haas
On Thu, Apr 8, 2010 at 7:05 AM, Thom Brown wrote: > On 8 April 2010 11:55, Ian Barwick wrote: >> >> 2010/4/8 Thom Brown : >> > I couldn't find any discussion on this, but the request is quite >> > straightforward.  Implement a LIMIT on DELETE statements like SELECT >> > statements. >> > >> > So y

Re: [HACKERS] [pgadmin-hackers] Feature request: limited deletions

2010-04-08 Thread Thom Brown
On 8 April 2010 11:55, Ian Barwick wrote: > 2010/4/8 Thom Brown : > > I couldn't find any discussion on this, but the request is quite > > straightforward. Implement a LIMIT on DELETE statements like SELECT > > statements. > > > > So you could write: > > > > DELETE FROM massive_table WHERE id <