On Wed, 17 Aug 2005 17:27:17 -0500
Puneet Kishor <[EMAIL PROTECTED]> wrote:
#> Maintaining the integrity of state is important when modifying.
#> While reading, why would you want to read something that is
#> possibly stale.
I don't think "stale" is a good word.
SELECT amount as a1 FROM money WHERE name = me;
SELECT amount as a2 FROM money WHERE name = you;
Now, how much money do we have together? a1 + a2? Yes, but only if the
above statements were wrapped in a transaction... otherwise, somebody
might have executed "BEGIN; UPDATE amount = amount + 1000 WHERE name =
me; UPDATE amount = amount - 1000 WHERE name = you; COMMIT" in-between
those two selects.
Integrity can be important :)
--
Best wishes,
Slawomir Nowaczyk
( [EMAIL PROTECTED] )
User Friendly: Supplied with a full color manual.
