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(at)it(dot)uc3m(dot)es>
To: <pgsql-general(at)postgresql(dot)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(at)postgresql(dot)org
>
>