Re: DELETE with LIMIT (or my first hack)

to me the key its security - its a anti-DBA-with-lack-of-attention feature. If i forget the "WHERE" statement, I will
deletesome valid tuples and messed up the bd, but its less-than-worst that exclude all the table. A DBA who never
forgotan "WHERE" in an "DELETE" is not an DBA. Just kidding, but this happens often enough.<br /><br />is there another
optionto implement this ? Its possible to be done by plugins/extension (in a Firefox browser style) ?<br /><br
/>Sds,<br/>--<br clear="all" />Daniel Loureiro<br />------------------------------<br /><br /><div class="gmail_quote">
2010/11/30Andrew Dunstan <span dir="ltr"><<a href="mailto:andrew@dunslane.net">andrew@dunslane.net</a>></span><br
/><blockquoteclass="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204);
padding-left:1ex;"><div bgcolor="#ffffff" text="#000000"><div class="im"><br /><br /> On 11/30/2010 09:57 AM, Csaba
Nagywrote: <blockquote type="cite"><br /><pre>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 :-)


</pre></blockquote><br /></div> We need a convincing use case for it. So far the only one that's seemed at all
convincingto me is the one about deleting in batches. But that might be enough.<br /><br /> As for it being illogical,
Idon't think it's any more so than<br /><blockquote>DELETE FROM foo WHERE random() < 0.1;<br /></blockquote> and you
cando that today.<br /><br /> cheers<br /><br /> andrew<br /><br /></div></blockquote></div><br />