Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Initial docs for tointeger() and toreal() SQL functions. |
|---|---|
| Timelines: | family | ancestors | descendants | both | toTypeFuncs |
| Files: | files | file ages | folders |
| SHA1: | 083cd58817e6d1749c6216dcddf6c3db |
| User & Date: | mistachkin 2013-08-19 21:17:13 |
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. |