Re: Conditional INSERT: if not exists

Don Morrison wrote:
> I want to insert a row unless it exists already.  Do I have to write a
> stored procedure to do this?

Hi, Don.

Just do the insert.  If it already exists, it simply isn't inserted.
You will, of course, receive an error that the row exists, but that
isn't a problem.  If you need to do this in a transaction, you can
simply set savepoints and roll back to the savepoint if an insert fails
(and you expected that it could).

Sean