Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Initial docs for tointeger() and toreal() SQL functions. |
|---|---|
| Downloads: | Tarball | ZIP archive |
| Timelines: | family | ancestors | descendants | both | toTypeFuncs |
| Files: | files | file ages | folders |
| SHA1: |
083cd58817e6d1749c6216dcddf6c3db |
| User & Date: | mistachkin 2013-08-19 21:17:13.981 |
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) | |
| 14:26 | Fix a typo in the RTREE documentation. (check-in: 9ceaba9f7f user: drh tags: trunk) | |
Changes
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 |
^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 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()]
C/C++ interface.
|
| ︙ | ︙ |