<br /><br /> On 11/29/2010 10:19 PM, Robert Haas wrote: <blockquote
cite="mid:AANLkTinsts6=TQD29J2WhQK37k58_i4jNVGsYn2c7xk5@mail.gmail.com"type="cite"><br /><pre wrap="">For example,
supposewe're trying to govern an ancient Greek
democracy:
<a class="moz-txt-link-freetext"
href="http://en.wikipedia.org/wiki/Ostracism">http://en.wikipedia.org/wiki/Ostracism</a>
DELETE FROM residents_of_athens ORDER BY ostracism_votes DESC LIMIT 1;
</pre></blockquote><br /> I'm not sure this is a very good example. Assuming there isn't a tie, I'd do it like this:<br
/><br/><blockquote>DELETE FROM residents_of_athens <br /> WHERE ostracism_votes >= 6000 <br /> and
ostracism_votes= <br /> (SELECT max(ostracism_votes) <br /> FROM residents_of_athens);<br /></blockquote><br
/><prewrap="">I can't say I'd be excited by this feature. In quite a few years of writing SQL I don't recall ever
wantingsuch a gadget.
cheers
andrew
</pre><br />