* Jeff Kowalczyk ([EMAIL PROTECTED]) wrote: > Is there a postgresql SQL idiom to perform an UPDATE, which becomes an > INSERT if the primary key does not exist? > > I'm not sure I *should* use it in my application, I just want to know if > it can be done. Thanks.
Unfortunately, I don't believe there's one in PostgreSQL yet. MERGE is similar to this, and is defined in the latest SQL spec. Hopefully it'll be implemented in PostgreSQL sometime soon. Stephen
signature.asc
Description: Digital signature