Small. Fast. Reliable.
Choose any three.
Choose any three.
Search results 11..18 of 18 for: cast
|
SQLite Version 3 Overview
(version3.html)
... Planned enhancements to SQLite are to include standard CAST() syntax
to allow the collating sequence of an expression to be defined.
64-bit ROWIDs
Every row of a table has a unique rowid.
If the table defines a column with ...
|
|
C/C++ Interface For SQLite Version 3 (old)
(capi3.html)
... Client software can cast the void*
to whatever datatype is appropriate for their system.
2.0 C/C++ Interface
The API for SQLite 3.0 includes 83 separate functions in addition
to several data structures and #defines. (A complete
API ...
|
|
Built-In Scalar SQL Functions
(lang_corefunc.html)
... If Z is not initially
a string, it is cast to a UTF-8 string prior to processing.
round(X)round(X,Y)
The round(X,Y) function returns a floating-point
value X rounded to Y digits to the ...
|
|
The WITH Clause
(lang_with.html)
... WITH RECURSIVE
input(sud) AS (
VALUES('53..7....6..195....98....6.8...6...34..8.3..17...2...6.6....28....419..5....8..79')
),
digits(z, lp) AS (
VALUES('1', 1)
UNION ALL SELECT
CAST(lp+1 AS ...
|
|
The SQLite Bytecode Engine
(opcode.html)
4. The Opcodes
... The content is
the same sequence of bytes, it is merely interpreted as a BLOB instead
of a string, as if it had been CAST. In other words:
if( P3!=0 and reg[P3]==P5 ) reg[P2 ...
|
|
Compile-time Options
(compile.html)
9. Options To Omit Features
... SQLITE_OMIT_CAST
This option causes SQLite to omit support for the CAST operator.
SQLITE_OMIT_CHECK
This option causes SQLite to omit support for CHECK constraints.
The parser will still accept CHECK constraints in SQL statements,
they will just not be enforced.
SQLITE_OMIT_COMPILEOPTION_DIAGS ...
|
|
JSON Functions And Operators
(json1.html)
3.8. The JSON BLOB Input Bug
If a JSON input is a BLOB that is not JSONB and that looks like
text JSON when cast to text, then it is accepted as text JSON.
This is actually a long-standing bug in the original implementation
that ...
|
|
SQLite FTS3 and FTS4 Extensions
(fts3.html)
10.1. UTF-16 byte-order-mark problem
... A text value created by casting a blob that begins with the two
bytes 0xFF and 0xFE, in either possible order, is inserted into an
FTS3 table. For example:
INSERT INTO fts_table(col) VALUES(CAST(X'FEFF' AS TEXT));
Everything ...
|
Page generated by FTS5 in about 37.51 ms.