3.8. The geopoly_contains_point(P,X,Y) Function If P is a polygon, then geopoly_contains_point(P,X,Y) returns a non-zero integer if and only if the coordinate X,Y is inside or on the boundary of the polygon P. If P is not a polygon, geopoly_contains_point ... 

 ... WITH RECURSIVE cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE x<1000000) SELECT x FROM cnt; Consider how this query works. The initial-select runs first and returns a single row with a single ... 

sqlite3_get_clientdata(), sqlite3_set_clientdata()

 ... If P and X are both non-NULL, then the destructor X is invoked with argument P on the first of the following occurrences: An out-of-memory error occurs during the call to sqlite3_set_clientdata() which attempts to register pointer ... 

 ... Transfer content from X into new_X using a statement like: INSERT INTO new_X SELECT ... FROM X. Drop the old table X: DROP TABLE X. Change the name of new_X to X using: ALTER TABLE new_X RENAME TO X. Use CREATE ... 

3. Queries Using Partial Indexes Let X be the expression in the WHERE clause of a partial index, and let W be the WHERE clause of a query that uses the table that is indexed. Then, the query is permitted to use the partial index ... 

SQLITE_VTAB_CONSTRAINT_SUPPORT, SQLITE_VTAB_INNOCUOUS, SQLITE_VTAB_DIRECTONLY, SQLITE_VTAB_USES_ALL_SCHEMAS

 ... SQLITE_VTAB_CONSTRAINT_SUPPORT Calls of the form sqlite3_vtab_config(db,SQLITE_VTAB_CONSTRAINT_SUPPORT,X) are supported, where X is an integer. If X is zero, then the virtual table whose xCreate or xConnect method invoked sqlite3_vtab_config() does not support constraints. In this configuration (which is ... 

sqlite3_str_new()

 ... To avoid memory leaks, the object returned by sqlite3_str_new() must be freed by a subsequent call to sqlite3_str_finish(X). The sqlite3_str_new(D) interface always returns a pointer to a valid sqlite3_str object, though in the event of an out-of ... 

 ... For example: /* Add a table named 't1' to the temp, main and an attached database */ ATTACH 'file.db' AS aux; CREATE TABLE t1(x, y); CREATE TEMP TABLE t1(x, y); CREATE TABLE aux.t1(x, y); DROP TABLE t1 ... 

sqlite3_vtab_nochange()

If the sqlite3_vtab_nochange(X) routine is called within the xColumn method of a virtual table, then it might return true if the column is being fetched as part of an UPDATE operation during which the column value will not change ... 

sqlite3_table_column_metadata()

The sqlite3_table_column_metadata(X,D,T,C,....) routine returns information about column C of table T in database D on database connection X. The sqlite3_table_column_metadata() interface returns SQLITE_OK and fills in the non-NULL pointers in the final five arguments with ...