Re: INSERT ON DUPLICATE KEY UPDATE

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