using limit with delete

From: Chris Smith <chris(at)interspire(dot)com>
To: psql-general(at)postgresql(dot)org
Subject: using limit with delete
Date: 2005-04-07 00:58:16
Message-ID: 425485A8.1040307@interspire.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I'm trying to use a limit clause with delete, but it doesn't work at the
moment (are there plans to add this - I could try to do up a patch ?).

eg.

delete from table where x='1' limit 1000;

Is there another way to approach this?

I'm trying to delete records through a webapp and if there are 500,000
records for example, I can't really leave the page open and expect it to
finish...

--
Regards,

Chris Smith

Unit 2, 3 National Street, Rozelle, NSW 2039 Australia

Ph: +61 2 9555 5570
Fx: +61 2 9555 5571

email: info(at)interspire(dot)com
web: http://www.interspire.com

Browse pgsql-general by date

  From Date Subject
Next Message Chris Smith 2005-04-07 01:51:10 using limit with delete
Previous Message Jamie Deppeler 2005-04-07 00:37:23 converting to hex