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

From NTPT
Subject Re: INSERT ON DUPLICATE KEY UPDATE
Date
Msg-id 003a01c455b1$8bb4f0c0$74beebd5@wbp1
Whole thread Raw
In response to INSERT ON DUPLICATE KEY UPDATE  (Eduardo Pérez Ureta <eperez@it.uc3m.es>)
List pgsql-general
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
>
>


pgsql-general by date:

Previous
From: "Luiz Rafael Culik Guimaraes"
Date:
Subject: Escape chars
Next
From: Tatsuo Ishii
Date:
Subject: pgpool 2.0RC1