Re: Re: REPLACE INTO table a la mySQL - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: Re: REPLACE INTO table a la mySQL
Date
Msg-id 3B2657CC.D876B1EF@tm.ee
Whole thread Raw
In response to Re: Re: REPLACE INTO table a la mySQL  (Jan Wieck <JanWieck@Yahoo.com>)
List pgsql-hackers
mlw wrote:
> 
> Dale Johnson wrote:
> 
> > "Jan Wieck" <JanWieck@Yahoo.com> wrote in message
> > news:200106061506.f56F6dV01843@jupiter.us.greatbridge.com...
> > > 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


pgsql-hackers by date:

Previous
From: Chris Bowlby
Date:
Subject: Re: Improving pg_hba.conf
Next
From: Hannu Krosing
Date:
Subject: Re: Re: REPLACE INTO table a la mySQL