Re: "Transactions are bad, real bad" - discuss

"Paul Vernon" <paul.vernon_at_ukk.ibmm.comm> wrote in message news:<b8p5dh$3356$1_at_gazette.almaden.ibm.com>...

> Personally, I'd be more than comfortable working in a system that did not
> support INSERT/UPDATE/DELETE shorthands. OK, so UPDATEs are slightly painful
> to write out long hand, but INSERT, DELETE are trivial (almost shorter when
> written as an assignment).
>
> Do you prefer
> INSERT INTO Parts VALUES (P34, 'A shiny new Hammer')
> or
> Parts := Parts UNION VALUES (P34, 'A shiny new Hammer')

Imagine this:

Parts := VALUES (P34, 'A shiny new Hammer'); Parts := Parts UNION VALUES (P34, 'A shiny new Hammer');

It should work without errors.

Parts := VALUES (P34, 'A shiny new Hammer'); INSERT INTO Parts VALUES (P34, 'A shiny new Hammer');

And this?

If they are equivalent (and they are), it should work without errors, unlike in SQL.

Do you agree?

Regards
  Alfredo Received on Sat May 03 2003 - 20:51:30 CEST