Re: INSERT ON DUPLICATE KEY UPDATE - Mailing list pgsql-general

From Eduardo Pérez Ureta
Subject Re: INSERT ON DUPLICATE KEY UPDATE
Date
Msg-id 20040618173927.GB654@localhost.localdomain
Whole thread Raw
In response to Re: INSERT ON DUPLICATE KEY UPDATE  (Duane Lee - EGOVX <DLee@mail.maricopa.gov>)
Responses Re: INSERT ON DUPLICATE KEY UPDATE  (Richard Huxton <dev@archonet.com>)
List 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@it.uc3m.es]
> Sent: Friday, June 18, 2004 9:38 AM
> To: pgsql-general@postgresql.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
> ?

pgsql-general by date:

Previous
From: Duane Lee - EGOVX
Date:
Subject: Re: INSERT ON DUPLICATE KEY UPDATE
Next
From: Richard Huxton
Date:
Subject: Re: INSERT ON DUPLICATE KEY UPDATE