Documentation Source Text
Check-in [85757c1492]
Not logged in

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

Overview
SHA1 Hash:85757c1492ce7f8c535c1d57480188f456f942cd
Date: 2013-08-20 03:06:08
User: drh
Comment:Revised and amplified definition of the tointeger() and toreal() functions.
Tags And Properties
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/lang.in

2310
2311
2312
2313
2314
2315
2316
2317
2318
2319



2320
2321
2322
2323
2324







2325
2326
2327
2328
2329
2330
2331
  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 any value (integer, double, or string) that can be losslessly
  converted into an integer, then make the conversion and return the result.
  Otherwise, return NULL.



}

funcdef {toreal(X)} {} {
  If X can be losslessly converted into a real number, then do so and return
  that real number.  Otherwise return 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()]







|
|
|
>
>
>



|
|
>
>
>
>
>
>
>







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
  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()]