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: |
e2d95f85a3c4beeb5f8e78498f52fc00 |
| 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
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.