REPLACE

From: Radovan Petrikí <r(dot)petrik(at)episoftware(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: REPLACE
Date: 2003-04-14 12:50:52
Message-ID: 1050324652.1035.17.camel@caj
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

In mysql exist this query
"REPLACE name_table (id,colum) VALUES(1,'test')";

When row id=1 exist then replace row.
When row id!=1 then insert row.

How this make in PostgreSQL ?

Rado.

Browse pgsql-sql by date

  From Date Subject
Next Message Rado Petrik 2003-04-14 13:09:43 REPLACE
Previous Message Christoph Haller 2003-04-14 11:16:13 Re: How Do I Hide Trigger ??