Re: [SQL] 'UPDATE OR INSERT' command

2004-07-15 Thread Stephen Frost
* 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 th

Re: [SQL] 'UPDATE OR INSERT' command

2004-07-15 Thread Bruno Wolff III
On Thu, Jul 15, 2004 at 13:20:57 -0500, 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. Th

[SQL] 'UPDATE OR INSERT' command

2004-07-15 Thread Jeff Kowalczyk
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. ---(end of broadcast)--- TIP 2: you ca