Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: INSERT OU UPDATE WITHOUT SELECT?
- From: "Jonah H. Harris" <jonah(dot)harris(at)gmail(dot)com>
- To: Waldomiro <waldomiro(at)shx(dot)com(dot)br>
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: INSERT OU UPDATE WITHOUT SELECT?
- Date: Tue, 30 May 2006 17:05:17 -0400
On 5/30/06, Waldomiro <waldomiro(at)shx(dot)com(dot)br> wrote:
Is there a command to Insert a record If It does not exists and a update if It exists?
Sure, it's called MERGE. See http://en.wikipedia.org/wiki/Merge_%28SQL%29
I mean the postgres should test if a record exist before insert and if It exist then the postgres must do an update instead an insert.
PostgreSQL does not support MERGE at the moment, sorry. -- Jonah H. Harris, Software Architect | phone: 732.331.1300 EnterpriseDB Corporation | fax: 732.331.1301 33 Wood Ave S, 2nd Floor | jharris(at)enterprisedb(dot)com Iselin, New Jersey 08830 | http://www.enterprisedb.com/
- Follow-Ups:
- Re: INSERT OU UPDATE WITHOUT SELECT?
- From: PFC
- Re: INSERT OU UPDATE WITHOUT SELECT?
- References:
- INSERT OU UPDATE WITHOUT SELECT?
- From: Waldomiro
- INSERT OU UPDATE WITHOUT SELECT?
- Prev by Date: Re: Adding and filling new column on big table
- Next by Date: Re: Split select completes, single select doesn't and
- Previous by thread: INSERT OU UPDATE WITHOUT SELECT?
- Next by thread: Re: INSERT OU UPDATE WITHOUT SELECT?
- Indexes: