Re: Re: REPLACE INTO table a la mySQL

From: Hannu Krosing <hannu(at)tm(dot)ee>
To: mlw <markw(at)mohawksoft(dot)com>
Cc: Dale Johnson <djohnson(at)mi(dot)ab(dot)ca>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Re: REPLACE INTO table a la mySQL
Date: 2001-06-12 17:56:28
Message-ID: 3B2657CC.D876B1EF@tm.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

mlw wrote:
>
> Dale Johnson wrote:
>
> > "Jan Wieck" <JanWieck(at)Yahoo(dot)com> wrote in message
> > news:200106061506(dot)f56F6dV01843(at)jupiter(dot)us(dot)greatbridge(dot)com(dot)(dot)(dot)
> > > mlw wrote:
> > > > [...]
> > > > REPLACE into table set xx=yy, ww = zz where ID = fubar;
> > > >
> > > > A MUCH better solution!
> > >
> > > Please solve the trigger problem at least theoretical before
> > > claiming that mySQL is that MUCH better. And please don't
> > > solve it by ripping out trigger support :-)

I was recently told about a similar feature coming to Oracle (or perhaps
already in v9.x)

Has anyone any knowledge of it ?

--------------------
Hannu

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Mike Cianflone 2001-06-12 17:57:40 vacuum
Previous Message Hannu Krosing 2001-06-12 17:50:06 Re: Implicit order-by in Postgresql?