On 9 Jul 2018, at 1:57pm, Aaron Elkins <threc...@yahoo.com> wrote: > Thank you for the interesting explanations for SQL specific cases, and I am > also interested in the SQL standard document after reading your email, can > you point me to the right place?
SQL-86 was the first widely-adopted SQL standard. However later standards added much-needed features to the language, giving it its dominant position throughout database programming. The 1992 version of SQL was the first and last document for what has become standard SQL: <http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt> You will note, for example, that there are still no DATE, TIME or DATETIME types. If you look at a later standard and don't know why it's weird, go back to this 1992 standard and see how the things in this standard guided what changes could be made without breaking compatibility. You can find (especially if you're willing to pay) standards for SQL since the 1992 one: 1999, 2003, 2006, 2008 etc.. However, they quickly became so large and complicated that no implementation of SQL implemented as much of the later standards as was done for the 1992 version. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
