/ Check-in [e2d95f85]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Documentation updates prior to the releae of 2.7.0. (CVS 728)
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1:e2d95f85a3c4beeb5f8e78498f52fc00475f38ed
User & Date: drh 2002-08-25 20:11:19
Context
2002-08-25
20:58
Version 2.7.0 (CVS 729) check-in: 9e341d9c user: drh tags: trunk
20:11
Documentation updates prior to the releae of 2.7.0. (CVS 728) check-in: e2d95f85 user: drh tags: trunk
19:20
Fix for ticket #136: Added the OP_RenameCursor VDBE instruction and used it to make cursor numbers right on nested subqueries. Also added OP_Gosub and OP_Return but have not actually used them for anything yet. (CVS 727) check-in: c602603e user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to www/changes.tcl.

    21     21   
    22     22   
    23     23   proc chng {date desc} {
    24     24     puts "<DT><B>$date</B></DT>"
    25     25     puts "<DD><P><UL>$desc</UL></P></DD>"
    26     26   }
    27     27   
    28         -chng {2002 Aug ?? (2.7.0)} {
           28  +chng {2002 Aug 25 (2.7.0)} {
    29     29   <li>Make a distinction between numeric and text values when sorting.
    30     30       Text values sort according to memcmp().  Numeric values sort in
    31     31       numeric order.</li>
    32     32   <li>Allow multiple simulataneous readers under windows by simulating
    33     33       the reader/writers locks that are missing from Win95/98/ME.</li>
           34  +<li>An error is now returned when trying to start a transaction if
           35  +    another transaction is already active.</li>
    34     36   }
    35     37   
    36     38   chng {2002 Aug 12 (2.6.3)} {
    37     39   <li>Add the ability to read both little-endian and big-endian databases.
    38     40       So database created under SunOS or MacOSX can be read and written
    39     41       under Linux or Windows and vice versa.</li>
    40     42   <li>Convert to the new website: http://www.sqlite.org/</li>

Changes to www/lang.tcl.

     1      1   #
     2      2   # Run this Tcl script to generate the sqlite.html file.
     3      3   #
     4         -set rcsid {$Id: lang.tcl,v 1.44 2002/08/18 19:09:24 drh Exp $}
            4  +set rcsid {$Id: lang.tcl,v 1.45 2002/08/25 20:11:19 drh Exp $}
     5      5   
     6      6   puts {<html>
     7      7   <head>
     8      8     <title>Query Language Understood By SQLite</title>
     9      9   </head>
    10     10   <body bgcolor=white>
    11     11   <h1 align=center>
................................................................................
   720    720   
   721    721   <p>Both simple and aggregate functions are supported.  A simple
   722    722   function can be used in any expression.  Simple functions return
   723    723   a result immediately based on their inputs.  Aggregate functions
   724    724   may only be used in a SELECT statement.  Aggregate functions compute
   725    725   their result across all rows of the result set.</p>
   726    726   
   727         -<p>The following simple functions are currently supported:</p>
          727  +<p>The functions shown below are available by default.  Additional
          728  +functions may be written in C and added to the database engine using
          729  +the <a href="c_interface.html#cfunc">sqlite_create_function()</a>
          730  +API.</p>
   728    731   
   729    732   <table border=0 cellpadding=10>
   730    733   <tr>
   731    734   <td valign="top" align="right" width=120>abs(<i>X</i>)</td>
   732    735   <td valign="top">Return the absolute value of argument <i>X</i>.</td>
   733    736   </tr>
   734    737   
   735    738   <tr>
   736    739   <td valign="top" align="right">coalesce(<i>X</i>,<i>Y</i>,...)</td>
   737    740   <td valign="top">Return a copy of the first non-NULL argument.  If
   738    741   all arguments are NULL then NULL is returned.</td>
   739    742   </tr>
   740    743   
          744  +<tr>
          745  +<td valign="top" align="right">glob(<i>X</i>,<i>Y</i>)</td>
          746  +<td valign="top">This function is used to implement the
          747  +"<b>Y GLOB X</b>" syntax of SQLite.  The
          748  +<a href="c_interface.html#cfunc">sqlite_create_function()</a> 
          749  +interface can
          750  +be used to override this function and thereby change the operation
          751  +of the GLOB operator.</td>
          752  +</tr>
          753  +
   741    754   <tr>
   742    755   <td valign="top" align="right">last_insert_rowid()</td>
   743    756   <td valign="top">Return the ROWID of the last row insert from this
   744    757   connection to the database.  This is the same value that would be returned
   745    758   from the <b>sqlite_last_insert_rowid()</b> API function.</td>
   746    759   </tr>
   747    760   
................................................................................
   748    761   <tr>
   749    762   <td valign="top" align="right">length(<i>X</i>)</td>
   750    763   <td valign="top">Return the string length of <i>X</i> in characters.
   751    764   If SQLite is configured to support UTF-8, then the number of UTF-8
   752    765   characters is returned, not the number of bytes.</td>
   753    766   </tr>
   754    767   
          768  +<tr>
          769  +<td valign="top" align="right">like(<i>X</i>,<i>Y</i>)</td>
          770  +<td valign="top">This function is used to implement the
          771  +"<b>Y LIKE X</b>" syntax of SQL.  The
          772  +<a href="c_interface.html#cfunc">sqlite_create_function()</a> 
          773  +interface can
          774  +be used to override this function and thereby change the operation
          775  +of the LIKE operator.</td>
          776  +</tr>
          777  +
   755    778   <tr>
   756    779   <td valign="top" align="right">lower(<i>X</i>)</td>
   757    780   <td valign="top">Return a copy of string <i>X</i> will all characters
   758    781   converted to lower case.  The C library <b>tolower()</b> routine is used
   759    782   for the conversion, which means that this function might not
   760    783   work correctly on UTF-8 characters.</td>
   761    784   </tr>
................................................................................
   807    830   upper-case letters.  The implementation of this function uses the C library
   808    831   routine <b>toupper()</b> which means it may not work correctly on 
   809    832   UTF-8 strings.</td>
   810    833   </tr>
   811    834   </table>
   812    835   
   813    836   <p>
   814         -The following aggregate functions are supported:
   815         -</p>
          837  +The following aggregate functions are available by default.  Additional
          838  +aggregate functions written in C may be added using the 
          839  +<a href="c_interface.html#cfunc">sqlite_create_aggregate()</a> API.</p>
   816    840   
   817    841   <table border=0 cellpadding=10>
   818    842   <tr>
   819    843   <td valign="top" align="right" width=120>avg(<i>X</i>)</td>
   820    844   <td valign="top">Return the average value of all <i>X</i> within a group.</td>
   821    845   </tr>
   822    846   
................................................................................
  1168   1192   <p>The SELECT statement is used to query the database.  The
  1169   1193   result of a SELECT is zero or more rows of data where each row
  1170   1194   has a fixed number of columns.  The number of columns in the
  1171   1195   result is specified by the expression list in between the
  1172   1196   SELECT and FROM keywords.  Any arbitrary expression can be used
  1173   1197   as a result.  If a result expression is }
  1174   1198   puts "[Operator *] then all columns of all tables are substituted"
  1175         -puts {for that one expression.</p>
         1199  +puts {for that one expression.  If the expression is the name of}
         1200  +puts "a table followed by [Operator .*] then the result is all columns"
         1201  +puts {in that one table.</p>
  1176   1202   
  1177   1203   <p>The query is executed against one or more tables specified after
  1178   1204   the FROM keyword.  If multiple tables names are separated by commas,
  1179   1205   then the query is against the cross join of the various tables.
  1180   1206   The full SQL-92 join syntax can also be used to specify joins.
  1181   1207   A sub-query
  1182   1208   in parentheses may be substituted for any table name in the FROM clause.