Re: [HACKERS] DELETE with LIMIT (or my first hack)

[Andrew Dunstan]

On 11/29/2010 10:19 PM, Robert Haas wrote:

For example, suppose we're trying to govern an ancient Greek
democracy:

http://en.wikipedia.org/wiki/Ostracism

DELETE FROM residents_of_athens ORDER BY ostracism_votes DESC LIMIT 1;



I'm not sure this is a very good example. Assuming there isn't a tie, 
I'd do it like this:

   DELETE FROM residents_of_athens
   WHERE ostracism_votes >= 6000
       and ostracism_votes =
        (SELECT max(ostracism_votes)
         FROM residents_of_athens);


I can't say I'd be excited by this feature. In quite a few years of writing SQL 
I don't recall ever wanting such a gadget.

cheers

andrew