Re: INSERT ON DUPLICATE KEY UPDATE

Something like

 INSERT OR UPDATE  TABLE  foo SET bar=something WHERE condition

in meaning of "try to insert, if some unique constraint for some column (or
index) fail, make just an update" would be nice....


----- Original Message -----
From: "Eduardo Pérez Ureta" <eperez@it.uc3m.es>
To: <pgsql-general@postgresql.org>
Sent: Friday, June 18, 2004 6:38 PM
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
> ?
>
> Eduardo
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>