Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Move the tointeger() and toreal() functions into an extension. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
6218782fdaad90409c66f9c56f82aba6 |
User & Date: | drh 2013-10-14 21:20:41.484 |
Context
2013-10-15
| ||
19:08 | Added the fts4aux languageid column. Fix typos in famous.html (check-in: cd0e9d17ed user: drh tags: trunk) | |
2013-10-14
| ||
21:20 | Move the tointeger() and toreal() functions into an extension. (check-in: 6218782fda user: drh tags: trunk) | |
19:36 | Add documentation for toInteger() and toReal(). (check-in: 782c63b8f0 user: drh tags: trunk) | |
Changes
Changes to pages/changes.in.
︙ | ︙ | |||
36 37 38 39 40 41 42 | modified columns are associated with foreign keys. <li>Added the [SQLITE_MINIMUM_FILE_DESCRIPTOR] compile-time option <li>Added the win32-longpath VFS on windows, permitting filenames up to 32K characters in length. <li>The [Date And Time Functions] are enhanced so that the current time (ex: julianday('now')) is always the same for multiple function invocations within the same [sqlite3_step()] call. | > | | 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 | modified columns are associated with foreign keys. <li>Added the [SQLITE_MINIMUM_FILE_DESCRIPTOR] compile-time option <li>Added the win32-longpath VFS on windows, permitting filenames up to 32K characters in length. <li>The [Date And Time Functions] are enhanced so that the current time (ex: julianday('now')) is always the same for multiple function invocations within the same [sqlite3_step()] call. <li>Add the "totype.c" extension, implementing the tointeger() and toreal() SQL functions. <li>[FTS4] queries are better able to make use of docid<$limit constraints to limit the amount of I/O required. <li>The [VACUUM] command packs the database about 1% tighter. <li>The sqlite3_analyzer utility program is updated to provide better descriptions and to compute a more accurate estimate for "Non-sequential pages" <li>Refactor the implementation of PRAGMA statements to improve parsing performance. <li>The directory used to hold temporary files on unix can now be set using |
︙ | ︙ |
Changes to pages/lang.in.
︙ | ︙ | |||
2329 2330 2331 2332 2333 2334 2335 | then the first character of the substring is found by counting from the right rather than the left. ^If Z is negative then the abs(Z) characters preceding the Y-th character are returned. ^If X is a string then characters indices refer to actual UTF-8 characters. ^If X is a BLOB then the indices refer to bytes. } | < < < < < < < < < < < < < | 2329 2330 2331 2332 2333 2334 2335 2336 2337 2338 2339 2340 2341 2342 2343 2344 2345 2346 2347 2348 2349 2350 | then the first character of the substring is found by counting from the right rather than the left. ^If Z is negative then the abs(Z) characters preceding the Y-th character are returned. ^If X is a string then characters indices refer to actual UTF-8 characters. ^If X is a BLOB then the indices refer to bytes. } funcdef {total_changes()} {} { ^The total_changes() function returns the number of row changes caused by INSERT, UPDATE or DELETE statements since the current database connection was opened. ^This function is a wrapper around the [sqlite3_total_changes()] C/C++ interface. } funcdef {trim(X) trim(X,Y)} {} { ^The trim(X,Y) function returns a string formed by removing any and all characters that appear in Y from both ends of X. ^If the Y argument is omitted, trim(X) removes spaces from both ends of X. } funcdef {typeof(X)} {} { |
︙ | ︙ |