Re: [GENERAL] INSERT ON DUPLICATE KEY UPDATE

2004-06-18 Thread Robert Treat
- EGOVX; [EMAIL PROTECTED] > Subject: Re: [GENERAL] INSERT ON DUPLICATE KEY UPDATE > > > Eduardo Pérez Ureta wrote: > > On 2004-06-18 17:19:40 UTC, Duane Lee - EGOVX wrote: > > > >>I would suspect you would need to write a trigger to do this. > > >

Re: [GENERAL] INSERT ON DUPLICATE KEY UPDATE

2004-06-18 Thread Duane Lee - EGOVX
Title: RE: [GENERAL] INSERT ON DUPLICATE KEY UPDATE I agree.  You could always do a SELECT and if the record was found then UPDATE otherwise INSERT.  A little more effort than MYSQL but again I don't believe the way MYSQL is allowing you to do it is standard. Duane -Original Me

Re: [GENERAL] INSERT ON DUPLICATE KEY UPDATE

2004-06-18 Thread Richard Huxton
Eduardo Pérez Ureta wrote: On 2004-06-18 17:19:40 UTC, Duane Lee - EGOVX wrote: I would suspect you would need to write a trigger to do this. It seems the mysql way of doing this is easier and safer. And non-standard AFAIK. Why is that not implemented in postgresql? Is it better done with a trigge

Re: [GENERAL] INSERT ON DUPLICATE KEY UPDATE

2004-06-18 Thread Eduardo Pérez Ureta
On 2004-06-18 17:19:40 UTC, Duane Lee - EGOVX wrote: > I would suspect you would need to write a trigger to do this. It seems the mysql way of doing this is easier and safer. Why is that not implemented in postgresql? Is it better done with a trigger or with any other way? Eduardo > -Origina

Re: [GENERAL] INSERT ON DUPLICATE KEY UPDATE

2004-06-18 Thread Duane Lee - EGOVX
Title: RE: [GENERAL] INSERT ON DUPLICATE KEY UPDATE I would suspect you would need to write a trigger to do this. -Original Message- From: Eduardo Pérez Ureta [mailto:[EMAIL PROTECTED]] Sent: Friday, June 18, 2004 9:38 AM To: [EMAIL PROTECTED] Subject: [GENERAL] INSERT ON DUPLICATE