using limit with delete
От
Chris Smith
Тема
using limit with delete
Дата
Msg-id
4254920E.5070604@interspire.com
Список
Дерево обсуждения
using limit with delete Chris Smith <chris@interspire.com>
Re: using limit with delete Bruno Wolff III <bruno@wolff.to>
Re: using limit with delete Neil Conway <neilc@samurai.com>
Re: using limit with delete Alvaro Herrera <alvherre@dcc.uchile.cl>
Re: using limit with delete Chris Smith <chris@interspire.com>
Re: using limit with delete Csaba Nagy <nagy@ecircle-ag.com>
Re: using limit with delete Chris Smith <chris@interspire.com>
Re: using limit with delete Chris Smith <chris@interspire.com>
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; (so truncate is out - I have a 'where' clause). 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@interspire.com web: http://www.interspire.com
В списке pgsql-general по дате отправления
