| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | Richard Broersma Jr <rabroersma(at)yahoo(dot)com> |
| Cc: | Vivek Khera <khera(at)kcilink(dot)com>, Colin Wetherbee <cww(at)denterprises(dot)org>, Ted Byers <r(dot)ted(dot)byers(at)rogers(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: SQL design pattern for a delta trigger? |
| Date: | 2007-12-11 02:10:19 |
| Message-ID: | 20071211021019.GA8917@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Richard Broersma Jr wrote:
> --- On Mon, 12/10/07, Ted Byers <r(dot)ted(dot)byers(at)rogers(dot)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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | bookman bookman | 2007-12-11 02:29:04 | How can I insert NULL into column with the type of timestamp? |
| Previous Message | Geoffrey | 2007-12-11 01:19:10 | Re: slony question |