Re: Do we always have to update or insert? Why can't we just relate?

From: David Portas <REMOVE_BEFORE_REPLYING_dportas_at_acm.org>
Date: 14 Oct 2005 06:34:54 -0700
Message-ID: <1129296894.441126.94770_at_g14g2000cwa.googlegroups.com>


> But there is still the conceptual part of my question. Do we really
> need insert and update?

No. Relational assignment is all you need for updates, inserts, deletes. According to both Codd and Date an RDBMS should support relational assignment. A "D" language must support relational assignment - it's a requirement. SQL does not support it.

-- 
David Portas 
SQL Server MVP 
--
Received on Fri Oct 14 2005 - 15:34:54 CEST

Original text of this message