Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Add documentation for the unicode() and char() functions. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
0b81bc6851d4aaad721936199ef26f8b |
User & Date: | drh 2013-02-25 14:52:04.868 |
Context
2013-02-25
| ||
15:48 | Record the incremental vacuum enhancements in the change-log for 3.7.16. (check-in: 638d9567ad user: drh tags: trunk) | |
14:52 | Add documentation for the unicode() and char() functions. (check-in: 0b81bc6851 user: drh tags: trunk) | |
2013-02-15
| ||
15:18 | Update the change log and pragma documentation for 3.7.16. (check-in: ba9b0b1040 user: drh tags: trunk) | |
Changes
Changes to pages/changes.in.
︙ | ︙ | |||
41 42 43 44 45 46 47 48 49 50 51 52 53 54 | hd_enable_main 1 } } chng {2013-03-12 (3.7.16)} { <li>Added the [PRAGMA foreign_key_check] command. <li>Added new extended error codes for all SQLITE_CONSTRAINT errors <li>Improved optimization of queries containing aggregate min() or max(). <li>Enhance virtual tables so that they can potentially use an index when the WHERE clause contains the IN operator. <li>Allow indices to be used for sorting even if prior terms of the index are constrained by IN operators in the WHERE clause. <li>Enhance the [PRAGMA table_info] command so that the "pk" column is an increasing integer to show the order of columns in the primary key. | > | 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 | hd_enable_main 1 } } chng {2013-03-12 (3.7.16)} { <li>Added the [PRAGMA foreign_key_check] command. <li>Added new extended error codes for all SQLITE_CONSTRAINT errors <li>Added SQL functions [unicode(A)] and [char(X1,...,XN)]. <li>Improved optimization of queries containing aggregate min() or max(). <li>Enhance virtual tables so that they can potentially use an index when the WHERE clause contains the IN operator. <li>Allow indices to be used for sorting even if prior terms of the index are constrained by IN operators in the WHERE clause. <li>Enhance the [PRAGMA table_info] command so that the "pk" column is an increasing integer to show the order of columns in the primary key. |
︙ | ︙ |
Changes to pages/lang.in.
︙ | ︙ | |||
2050 2051 2052 2053 2054 2055 2056 2057 2058 2059 2060 2061 2062 2063 | funcdef {changes()} {} { ^The changes() function returns the number of database rows that were changed or inserted or deleted by the most recently completed INSERT, DELETE, or UPDATE statement, exclusive of statements in lower-level triggers. ^The changes() SQL function is a wrapper around the [sqlite3_changes()] C/C++ function and hence follows the same rules for counting changes. } funcdef {coalesce(X,Y,...)} {} { ^The coalesce() function returns a copy of its first non-NULL argument, or NULL if all arguments are NULL. ^Coalesce() must be at least 2 arguments. } | > > > > > | 2050 2051 2052 2053 2054 2055 2056 2057 2058 2059 2060 2061 2062 2063 2064 2065 2066 2067 2068 | funcdef {changes()} {} { ^The changes() function returns the number of database rows that were changed or inserted or deleted by the most recently completed INSERT, DELETE, or UPDATE statement, exclusive of statements in lower-level triggers. ^The changes() SQL function is a wrapper around the [sqlite3_changes()] C/C++ function and hence follows the same rules for counting changes. } funcdef {char(X1,X2,...,XN)} {} { ^The char(X1,X2,...,XN) function returns a string composed of characters having the unicode code point values of integers X1 thorugh XN, respectively. } funcdef {coalesce(X,Y,...)} {} { ^The coalesce() function returns a copy of its first non-NULL argument, or NULL if all arguments are NULL. ^Coalesce() must be at least 2 arguments. } |
︙ | ︙ | |||
2313 2314 2315 2316 2317 2318 2319 2320 2321 2322 2323 2324 2325 2326 | ^If the Y argument is omitted, trim(X) removes spaces from both ends of X. } funcdef {typeof(X)} {} { ^The typeof(X) function returns a string that indicates the [datatype] of the expression X: "null", "integer", "real", "text", or "blob". } funcdef {upper(X)} {} { ^The upper(X) function returns a copy of input string X in which all lower-case ASCII characters are converted to their upper-case equivalent. } funcdef {zeroblob(N)} {} { | > > > > > > | 2318 2319 2320 2321 2322 2323 2324 2325 2326 2327 2328 2329 2330 2331 2332 2333 2334 2335 2336 2337 | ^If the Y argument is omitted, trim(X) removes spaces from both ends of X. } funcdef {typeof(X)} {} { ^The typeof(X) function returns a string that indicates the [datatype] of the expression X: "null", "integer", "real", "text", or "blob". } funcdef {unicode(X)} {} { ^The unicode(X) function returns the numeric unicode code point corresponding to the first character of the string X. ^If the argument to unicode(X) is not a string then the result is undefined. } funcdef {upper(X)} {} { ^The upper(X) function returns a copy of input string X in which all lower-case ASCII characters are converted to their upper-case equivalent. } funcdef {zeroblob(N)} {} { |
︙ | ︙ |