Re: SQL design pattern for a delta trigger? - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: SQL design pattern for a delta trigger?
Date
Msg-id 20071211021019.GA8917@alvh.no-ip.org
Whole thread Raw
In response to Re: SQL design pattern for a delta trigger?  (Richard Broersma Jr <rabroersma@yahoo.com>)
List pgsql-general
Richard Broersma Jr wrote:
> --- On Mon, 12/10/07, Ted Byers <r.ted.byers@rogers.com> wrote:
>
> > but how do you
> > do it using SQL in an RDBMS?
>
> I believe that there is an ANSI SQL command "MERGE" that is yet to be implemented into PostgreSQL.

IIRC the standard's definition of MERGE is still subject to the race
condition :-)  It seems mostly defined for OLAP, and assumes rather
static data.

--
Alvaro Herrera                 http://www.amazon.com/gp/registry/DXLWNGRJD34J
"La tristeza es un muro entre dos jardines" (Khalil Gibran)

pgsql-general by date:

Previous
From: Geoffrey
Date:
Subject: Re: slony question
Next
From: Tom Lane
Date:
Subject: Re: partitioned table query question