Re: "Transactions are bad, real bad" - discuss
From: Alfredo Novoa <alfredo_at_ncs.es>
Date: 3 May 2003 11:41:35 -0700
Message-ID: <e4330f45.0305031041.737af3c6_at_posting.google.com>
Date: 3 May 2003 11:41:35 -0700
Message-ID: <e4330f45.0305031041.737af3c6_at_posting.google.com>
"Mikito Harakiri" <mikharakiri_at_ywho.com> wrote in message news:<C1Vra.7$i92.25_at_news.oracle.com>...
> > What about?
> >
> > update Accounts set Balance := Balance - 1000000
> > where AccountOwner = 'Paul Vernon',
> > update Accounts set Balance := Balance + 1000000
> > where AccountOwner = 'Jonathan Leffler';
> >
> > It is a lot easier to understand.
>
> Certainly easier to understand, but Paul suggested that any set of updates
> can be equivalently expressed as a single update.
But my proposal is a single update expression!
See the comma on the second's line end.
Regards
Alfredo
Received on Sat May 03 2003 - 20:41:35 CEST