Re: INSERT ON DUPLICATE KEY UPDATE

From: Eduardo Pérez Ureta <eperez(at)it(dot)uc3m(dot)es>
To: Duane Lee - EGOVX <DLee(at)mail(dot)maricopa(dot)gov>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: INSERT ON DUPLICATE KEY UPDATE
Date: 2004-06-18 17:39:27
Message-ID: 20040618173927.GB654@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

> -----Original Message-----
> From: Eduardo Pérez Ureta [mailto:eperez(at)it(dot)uc3m(dot)es]
> Sent: Friday, June 18, 2004 9:38 AM
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] INSERT ON DUPLICATE KEY UPDATE
>
>
> How may I do a INSERT ON DUPLICATE KEY UPDATE like in mysql:
> http://dev.mysql.com/doc/mysql/en/INSERT.html
> ?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2004-06-18 18:02:18 Re: INSERT ON DUPLICATE KEY UPDATE
Previous Message Duane Lee - EGOVX 2004-06-18 17:19:40 Re: INSERT ON DUPLICATE KEY UPDATE