Re: peer review: recipe for solving SELECT/INSERT/UPDATE race condition

Stuart Cooper wrote:
>> Sometimes it's desirable to first to a SELECT to see if a row exists,
>> and then INSERT if it doesn't already, or UPDATE if it does.
> 
> MySQL's got a really handy 'REPLACE INTO' for just this circumstance,
> some have suggested that PostgreSQL should support this in future.

The SQL 2003 Standard has a really handy "MERGE INTO" for just this 
circumstance, too. You can search for "MERGE INTO" on this page to read 
about it:
http://www.varlena.com/GeneralBits/73.php

I hope both PostgreSQL and MySQL support this in the future.

> Your solution looks good.

Thanks.

       Mark

-- 
http://mark.stosberg.com/

• peer review: recipe for solving SELECT/INSERT/UPDATE race condition by Mark Stosberg
• Re: peer review: recipe for solving SELECT/INSERT/UPDATE race condition by Stuart Cooper
• Re: peer review: recipe for solving SELECT/INSERT/UPDATE race condition by Mark Stosberg