Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Do we always have to update or insert? Why can't we just relate?

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

From: JOG <jog_at_cs.nott.ac.uk>
Date: 17 Oct 2005 16:28:22 -0700
Message-ID: <1129591702.871229.101110@f14g2000cwb.googlegroups.com>


Given two sets {2, 3, 4} and {3, 4, 5}, if I wanted to perform a union upon them, I would expect to get the result {2, 3, 4, 5} and not an error message stating the 3 and 4 existed in both. Is this analagous to an insert? If this is the case, with an insert viewed as the union of the relation's existing set of elements with specified insert set (which just contains a single element), then from a purely theoretical standpoint an error message does seem suprising. Received on Mon Oct 17 2005 - 18:28:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US