Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Changes In Branch toTypeFuncs Excluding Merge-Ins
This is equivalent to a diff from 9ceaba9f7f to 85757c1492
2013-08-20
| ||
17:06 | Fix typos in the cache_spill pragma documentation. (check-in: 4bfef7edb7 user: drh tags: trunk) | |
03:06 | Revised and amplified definition of the tointeger() and toreal() functions. (Leaf check-in: 85757c1492 user: drh tags: toTypeFuncs) | |
2013-08-19
| ||
21:17 | Initial docs for tointeger() and toreal() SQL functions. (check-in: 083cd58817 user: mistachkin tags: toTypeFuncs) | |
14:26 | Fix a typo in the RTREE documentation. (check-in: 9ceaba9f7f user: drh tags: trunk) | |
2013-08-17
| ||
17:56 | Add documentation for the cache_spill pragma. (check-in: 74740a2d9e user: drh tags: trunk) | |
Changes to pages/lang.in.
︙ | ︙ | |||
2308 2309 2310 2311 2312 2313 2314 2315 2316 2317 2318 2319 2320 2321 | ^The left-most character of X is number 1. ^If Y is negative 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. | > > > > > > > > > > > > > > > > > > > > > | 2308 2309 2310 2311 2312 2313 2314 2315 2316 2317 2318 2319 2320 2321 2322 2323 2324 2325 2326 2327 2328 2329 2330 2331 2332 2333 2334 2335 2336 2337 2338 2339 2340 2341 2342 | ^The left-most character of X is number 1. ^If Y is negative 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 {tointeger(X)} {} { If X is an integer then tointeger(X) returns X. If X is a floating point number or a string that can be losslessly converted into a 64-bit signed integer then tointeger(X) returns that integer. If X is NULL or a BLOB or a floating point number that cannot be represented as a 64-bit signed integer or a string that contains whitespace or a string that does not describe a 64-bit signed integer, then tointeger(X) returns NULL. } funcdef {toreal(X)} {} { If X is a floating point number then toreal(X) returns X. If X is an integer that can be converted into a 64-bit IEEE-754 floating point number with no loss of precision, then toreal(X) returns that number. If X is a string that describes a floating point number, then toreal(X) returns that number or a close approximation. If X is NULL or a BLOB or an integer that is too large to be losslessly converted into a 64-bit IEEE-754 number or a string that contains whitespace or a string that does not describe a floating point value, then toreal(X) returns NULL. } 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. |
︙ | ︙ |