Small. Fast. Reliable.
Choose any three.
Choose any three.
|
DELETE
(lang_delete.html)
... If a WHERE clause is supplied, then only those rows for which the
WHERE clause boolean expression is true are deleted.
Rows for which the expression is false or NULL are retained.
2. Restrictions on DELETE Statements Within CREATE TRIGGER ...
|
|
C API: Configuration Options
(c3ref/c_config_covering_index_scan.html)
SQLITE_CONFIG_SINGLETHREAD, SQLITE_CONFIG_MULTITHREAD, SQLITE_CONFIG_SERIALIZED, SQLITE_CONFIG_MALLOC, SQLITE_CONFIG_GETMALLOC, SQLITE_CONFIG_SCRATCH ...
... SQLITE_CONFIG_SMALL_MALLOC
The SQLITE_CONFIG_SMALL_MALLOC option takes single argument of
type int, interpreted as a boolean, which if true provides a hint to
SQLite that it should avoid large memory allocations if possible.
SQLite will run faster if it is free to ...
|
|
The Geopoly Interface To The SQLite R*Tree Module
(geopoly.html)
3.1. The geopoly_overlap(P1,P2) Function
... The geopoly_overlap(P1,P2) function is special in that the geopoly virtual
table knows how to use R*Tree indexes to optimize queries in which the
WHERE clause uses geopoly_overlap() as a boolean function. Only the
geopoly_overlap(P1,P2) and ...
|
|
C API: Opening A New Database Connection
(c3ref/open.html)
sqlite3_open(), sqlite3_open16()
... The nolock parameter is a boolean query parameter
which if set disables file locking in rollback journal modes. This
is useful for accessing a database on a filesystem that does not
support locking. Caution: Database corruption might result if two ...
|
|
Datatypes In SQLite
(datatype3.html)
2.1. Boolean Datatype
SQLite does not have a separate Boolean storage class.
Instead, Boolean values are stored as integers 0 (false) and 1 (true).
SQLite recognizes the keywords "TRUE" and "FALSE",
as of version 3.23.0 (2018-04-02) but those keywords ...
|
|
Powersafe Overwrite
(psow.html)
... Powersafe overwrite
is a boolean property: either the storage system has it or it does not.
We say that a system has the powersafe overwrite property if the following
statement is true:
When an application writes a range of bytes ...
|
|
SELECT
(lang_select.html)
... If there is an ON clause then the ON expression is
evaluated for each row of the cartesian product as a
boolean expression. Only rows for which the expression evaluates to
true are included from the dataset.
If there is ...
|
|
UPDATE
(lang_update.html)
... Otherwise, the UPDATE affects only those
rows for which the WHERE clause
boolean expression is true. It is not an error if the
WHERE clause does not evaluate to true for any row in the table - this just
means that ...
|
|
SQLite Changes From Version 3.5.9 To 3.6.0
(35to36.html)
... The signature of the xCheckReservedLock method on sqlite3_io_methods
has been modified so that it returns an error code and stores its
boolean result into an integer pointed to by a parameter. In
association with this change, a new extended error ...
|
|
Partial Indexes
(partialindex.html)
2.1. Unique Partial Indexes
... CREATE TABLE person(
person_id INTEGER PRIMARY KEY,
team_id INTEGER REFERENCES team,
is_team_leader BOOLEAN,
-- other fields elided
);
The team_id field cannot be unique because there are usually multiple people
on the same team. One cannot make the combination of team_id and ...
|
Page generated by FTS5 in about 123.77 ms.