Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!zaphod.mps.ohio-state.edu!swrinde!elroy.jpl.nasa.gov!decwrl!mejac!orchard.la.locus.com!prodnet.la.locus.com!jfr From: jfr@locus.com (Jon Rosen) Newsgroups: comp.databases Subject: Re: ANSI SQL Levels Message-ID: <23797@dice.la.locus.com> Date: 24 Apr 91 20:13:15 GMT References: Distribution: comp Organization: Locus Computing Corp, Los Angeles Lines: 34 In article av@uta.fi (Arto V. Viitanen) writes: >>>>>> On 22 Apr 91 21:32:43 GMT, davids@uunet!texsun!gdfwc3 (David Reed Smith) said: > >David> Can anyone summarize the differences between ANSI SQL level 1 and >David> level 2? Thank you. > >According to Rick F. van der Lans, "The SQL Standard, A Complete Reference", >Prentice Hall (ISBN 0-13-840059-8), pages 97-98: > >Two levels of the SQL standard have been defined. ... Level 1 is a subset of >level 2. In fact, level 2 encompasses level 1. The following definitions do >not occur in level 1: > > Just to remind everyone... ANSI SQL Level 2 as described in Arto's post is very distinct from ANSI SQL2 which is a completely new draft standard that has not been approved as of yet (Level 1 and Level 2 of ANSI SQL are already approved, along with the Referential Integrity addendum). ANSI SQL2 adds the proverbial kitchen sink to SQL, including triggers, CASE constructs, enhanced orthogonal use of queries (in just about any case, any query expression can be used where a table name could otherwise be used), additional functions, DATE/TIME/INTERVAL definitions, extended referential integrity, domains, and on and on and on... Jon Rosen ========================================================= "Another birthday? Well, don't worry about getting old until you can't make sense out of the simplest things... ... isn't it?" -- from my favorite 40th birthday card =========================================================