- 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.
> >
>
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
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
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
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