... User-defined Collating Sequences A collating sequence is just a defined order for text. When SQLite 3.0 sorts (or uses a comparison operator like "<" or ">=") the sort order is first determined by the data type. NULLs sort ... 

2. Creating Partial Indexes Create a partial index by adding a WHERE clause to the end of an ordinary CREATE INDEX statement. create-index-stmt: hide expr: show filter-clause: show function-arguments: show ordering-term: show literal-value: show over-clause: show frame ... 

 ... The INDEXED BY and NOT INDEXED clauses are not supported for UPDATE and DELETE statements. The ORDER BY and LIMIT clauses on UPDATE and DELETE statements are not supported. ORDER BY and LIMIT are not normally supported for UPDATE or ... 

sqlite3_bind_blob(), sqlite3_bind_blob64(), sqlite3_bind_double(), sqlite3_bind_int(), sqlite3_bind_int64(), sqlite3_bind_null ... 

 ... The byte-order of UTF16 input text is determined by the byte-order mark (BOM, U+FEFF) found in first character, which is removed, or in the absence of a BOM the byte order is the native byte order of ... 

3.1. Scrolling Window Queries Suppose an application wants to display a list of contacts in alphabetical order by lastname, firstname, in a scrolling window that can only show 7 contacts at a time. Initialize the scrolling window to the first 7 entries is easy ... 

sqlite3_snapshot_open()

 ... In order to succeed, the database connection must not be in autocommit mode when sqlite3_snapshot_open(D,S,P) is called. If there is already a read transaction open on schema S, then the database handle must have no active statements ... 

2.8. Transient Indices  ... SQLite implements GROUP BY by ordering the output rows in the order suggested by the GROUP BY terms. Each output row is compared to the previous to see if it starts a new "group". The ordering by GROUP BY terms ... 

struct sqlite3_vtab_cursor

 ... Cursors are used by the xFilter, xNext, xEof, xColumn, and xRowid methods of the module. Each module implementation will define the content of a cursor structure to suit its own needs. This superclass exists in order to define fields of ... 

sqlite3_overload_function()

 ... So the new function is not good for anything by itself. Its only purpose is to be a placeholder function that can be overloaded by a virtual table. See also lists of Objects, Constants, and Functions.

 ... Used by:   sql-stmt References:   common-table-expression   expr   ordering-term   qualified-table-name   returning-clause See also:   lang_delete.html detach-stmt: Used by:   ...