Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Revised and amplified definition of the tointeger() and toreal() functions. |
|---|---|
| Downloads: | Tarball | ZIP archive |
| Timelines: | family | ancestors | toTypeFuncs |
| Files: | files | file ages | folders |
| SHA1: |
85757c1492ce7f8c535c1d57480188f4 |
| User & Date: | drh 2013-08-20 03:06:08.664 |
Context
|
2013-08-20
| ||
| 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) | |
Changes
Changes to pages/lang.in.
| ︙ | ︙ | |||
2310 2311 2312 2313 2314 2315 2316 |
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)} {} {
| | | > > > | > > > > > > | > | | 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()]
|
| ︙ | ︙ |