Dale Johnson wrote: > > I know we're not in the business of copying mySQL, > but the REPLACE INTO table (...) values (...) could be > a useful semantic. This is a combination INSERT or > UPDATE statement. For one thing, it is atomic, and > easier to work with at the application level. Also > if the application doesn't care about previous values, > then execution has fewer locking issues and race > conditions. > > comments? > > Dale Johnson I don't know if it is standard SQL, but it will save hundreds of lines of code in applications everywhere. I LOVE the idea. I just finished writing a database merge/update program which could have been made much easier to write with this syntax. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
