Path: utzoo!mnetor!uunet!husc6!cmcl2!brl-adm!umd5!uvaarpa!mcnc!decvax!mandrill!hal!ncoast!allbery
From: allbery@ncoast.UUCP (Brandon Allbery)
Newsgroups: comp.databases
Subject: Re: SQL question
Message-ID: <7461@ncoast.UUCP>
Date: 5 Mar 88 17:16:38 GMT
References: <34358UH2@PSUVM> <43005@sun.uucp> <34586UH2@PSUVM>
Reply-To: allbery@ncoast.UUCP (Brandon Allbery)
Followup-To: comp.databases
Organization: Cleveland Public Access UN*X, Cleveland, Oh
Lines: 15

As quoted from <34586UH2@PSUVM> by UH2@PSUVM.BITNET (Lee Sailer):
+---------------
| One of the characterisitcs of SQL, I thought, was that there are ONLY
| 4 operators, SELECT, INSERT, DELETE, and UPDATE.
| So, how come it is said that SQL has only 4 operators, when obviously
| there are more?
+---------------

Because, strictly speaking, UNION is a sub-operator of SELECT; you can't
UNION two INSERT statements or etc.  (You can, however, say INSERT ... SELECT
... UNION SELECT ..., at least in theory.  Implementation depends on how
completely the DBMS implements SQL.)
-- 
	      Brandon S. Allbery, moderator of comp.sources.misc
       {well!hoptoad,uunet!hnsurg3,cbosgd,sun!mandrill}!ncoast!allbery