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

• branch=trunk inherited from [b2e03e19ab]
• sym-trunk inherited from [b2e03e19ab]

Changes to pages/changes.in

   41      hd_enable_main 1                                                                  41      hd_enable_main 1
   42    }                                                                                   42    }
   43  }                                                                                     43  }
   44                                                                                        44  
   45  chng {2013-03-12 (3.7.16)} {                                                          45  chng {2013-03-12 (3.7.16)} {
   46  <li>Added the [PRAGMA foreign_key_check] command.                                     46  <li>Added the [PRAGMA foreign_key_check] command.
   47  <li>Added new extended error codes for all SQLITE_CONSTRAINT errors                   47  <li>Added new extended error codes for all SQLITE_CONSTRAINT errors
                                                                                        >    48  <li>Added SQL functions [unicode(A)] and [char(X1,...,XN)].
   48  <li>Improved optimization of queries containing aggregate min() or max().             49  <li>Improved optimization of queries containing aggregate min() or max().
   49  <li>Enhance virtual tables so that they can potentially use an index when             50  <li>Enhance virtual tables so that they can potentially use an index when
   50      the WHERE clause contains the IN operator.                                        51      the WHERE clause contains the IN operator.
   51  <li>Allow indices to be used for sorting even if prior terms of the index             52  <li>Allow indices to be used for sorting even if prior terms of the index
   52      are constrained by IN operators in the WHERE clause.                              53      are constrained by IN operators in the WHERE clause.
   53  <li>Enhance the [PRAGMA table_info] command so that the "pk" column is an             54  <li>Enhance the [PRAGMA table_info] command so that the "pk" column is an
   54      increasing integer to show the order of columns in the primary key.               55      increasing integer to show the order of columns in the primary key.

Changes to pages/lang.in

 2050  funcdef {changes()} {} {                                                            2050  funcdef {changes()} {} {
 2051    ^The changes() function returns the number of database rows that were changed     2051    ^The changes() function returns the number of database rows that were changed
 2052    or inserted or deleted by the most recently completed INSERT, DELETE,             2052    or inserted or deleted by the most recently completed INSERT, DELETE,
 2053    or UPDATE statement, exclusive of statements in lower-level triggers.             2053    or UPDATE statement, exclusive of statements in lower-level triggers.
 2054    ^The changes() SQL function is a wrapper around the [sqlite3_changes()]           2054    ^The changes() SQL function is a wrapper around the [sqlite3_changes()]
 2055    C/C++ function and hence follows the same rules for counting changes.             2055    C/C++ function and hence follows the same rules for counting changes.
 2056  }                                                                                   2056  }
                                                                                        >  2057  
                                                                                        >  2058  funcdef {char(X1,X2,...,XN)} {} {
                                                                                        >  2059    ^The char(X1,X2,...,XN) function returns a string composed of characters havin
                                                                                        >  2060     unicode code point values of integers X1 thorugh XN, respectively.
                                                                                        >  2061  }
 2057                                                                                      2062  
 2058  funcdef {coalesce(X,Y,...)} {} {                                                    2063  funcdef {coalesce(X,Y,...)} {} {
 2059    ^The coalesce() function returns a copy of its first non-NULL argument, or        2064    ^The coalesce() function returns a copy of its first non-NULL argument, or
 2060    NULL if all arguments are NULL.  ^Coalesce() must be at least                     2065    NULL if all arguments are NULL.  ^Coalesce() must be at least
 2061    2 arguments.                                                                      2066    2 arguments.
 2062  }                                                                                   2067  }
 2063                                                                                      2068  
................................................................................................................................................................................

 2313    ^If the Y argument is omitted, trim(X) removes spaces from both ends of X.        2318    ^If the Y argument is omitted, trim(X) removes spaces from both ends of X.
 2314  }                                                                                   2319  }
 2315                                                                                      2320  
 2316  funcdef {typeof(X)} {} {                                                            2321  funcdef {typeof(X)} {} {
 2317    ^The typeof(X) function returns a string that indicates the [datatype] of         2322    ^The typeof(X) function returns a string that indicates the [datatype] of
 2318    the expression X: "null", "integer", "real", "text", or "blob".                   2323    the expression X: "null", "integer", "real", "text", or "blob".
 2319  }                                                                                   2324  }
                                                                                        >  2325  
                                                                                        >  2326  funcdef {unicode(X)} {} {
                                                                                        >  2327    ^The unicode(X) function returns the numeric unicode code point corresponding 
                                                                                        >  2328    the first character of the string X.  ^If the argument to unicode(X) is not a 
                                                                                        >  2329    then the result is undefined.
                                                                                        >  2330  }
 2320                                                                                      2331  
 2321  funcdef {upper(X)} {} {                                                             2332  funcdef {upper(X)} {} {
 2322    ^The upper(X) function returns a copy of input string X in which all              2333    ^The upper(X) function returns a copy of input string X in which all
 2323    lower-case ASCII characters are converted to their upper-case equivalent.         2334    lower-case ASCII characters are converted to their upper-case equivalent.
 2324  }                                                                                   2335  }
 2325                                                                                      2336  
 2326  funcdef {zeroblob(N)} {} {                                                          2337  funcdef {zeroblob(N)} {} {