Documentation Source Text

    modified columns are associated with foreign keys.
<li>Added the [SQLITE_MINIMUM_FILE_DESCRIPTOR] compile-time option
<li>Added the win32-longpath VFS on windows, permitting filenames up to 32K
    characters in length.
<li>The [Date And Time Functions] are enhanced so that the current time
    (ex: julianday('now')) is always the same for multiple function invocations
    within the same [sqlite3_step()] call.
<li>Added the [tointeger()] and [toreal()] SQL functions.
<li>[FTS4] queries are better able to make use of docid<$limit constraints to
    limit the amount of I/O required.
<li>The [VACUUM] command packs the database about 1% tighter.
<li>The sqlite3_analyzer utility program is updated to provide better descriptions
    and to compute a more accurate estimate for "Non-sequential pages"
<li>Refactor the implementation of PRAGMA statements to improve parsing performance.
<li>The directory used to hold temporary files on unix can now be set using

  ^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, blob, or string) that can be
  losslessly converted into an integer, then make the conversion
  and return the result.  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.
}

funcdef {toreal(X)} {} {
  ^(If X is any value (integer, double, blob, or string) that can be
  converted into a real number will preserving at least 15 significant
  digits of precision, then make the conversion and return the resulting
  floating point number.  Otherwise return NULL.)^
}

funcdef {trim(X) trim(X,Y)} {} {
  ^The trim(X,Y) function returns a string formed by removing any and all
  characters that appear in Y from both ends of X.
  ^If the Y argument is omitted, trim(X) removes spaces from both ends of X.
}