INSERT OU UPDATE WITHOUT SELECT?

From: Waldomiro <waldomiro(at)shx(dot)com(dot)br>
To: pgsql-performance(at)postgresql(dot)org
Subject: INSERT OU UPDATE WITHOUT SELECT?
Date: 2006-05-30 18:29:49
Message-ID: 447C8F1D.8090404@shx.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,

Is there a command to Insert a record If It does not exists and a update
if It exists?

I do not want to do a select before a insert or update.

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.

Thanks,

WMiro.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Daniel J. Luke 2006-05-30 19:59:19 Re: Getting even more insert performance (250m+rows/day)
Previous Message Francisco Reyes 2006-05-30 17:25:35 Re: Adding and filling new column on big table