On Apr 3, 2014, at 2:28 PM, Isha <[email protected]> wrote: > Hi, > > I was wondering if there is a specific reason why delete_all does not accept > limits? Ultimately, I want to achieve batched deletes in my application and > something like delete_in_batches or even delete_allthat accepts limits would > be useful. > > I can try adding this but wanted to get some feedback/suggestions first.
FWIW, passing a LIMIT clause to a DELETE is included in the SQL92 standard, but actually-implemented support is spotty: * Postgres: not supported * Oracle: not supported (but maybe hackable with ROWNUM tricks) * SQLite3: supported if enabled at compile time * MySQL: supported * SQL Server: not supported (but maybe with a TOP subquery?) —Matt Jones
signature.asc
Description: Message signed with OpenPGP using GPGMail
