Documentation Source Text

Check-in [a43ee1e871]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Adding additional comparison operators to the list in datatype3.html.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: a43ee1e87137fae752e81ca1125c7e63cbbe4114
User & Date: drh 2010-09-14 19:10:08.000
Context
2010-09-15
18:54
Changes to make the documentation for ORDER BY more testable. (check-in: 095cad2463 user: dan tags: trunk)
2010-09-14
19:10
Adding additional comparison operators to the list in datatype3.html. (check-in: a43ee1e871 user: drh tags: trunk)
18:57
Fix a recently introduced error regarding collation sequences and compounds SELECT statements. (check-in: 8d9fe20890 user: dan tags: trunk)
Changes
Side-by-Side Diff Ignore Whitespace Patch
Changes to pages/datatype3.in.
301
302
303
304
305
306
307
308


309
310
311
312
313
314
315
301
302
303
304
305
306
307

308
309
310
311
312
313
314
315
316







-
+
+







</pre>
</blockquote>)^

<tcl>hd_fragment comparisons {comparison expressions}</tcl>
<h2>3.0 Comparison Expressions</h2>

<p>SQLite version 3 has the usual set of SQL comparison operators
including "=", "&lt;", "&lt;=", "&gt;=", "!=", "<>", "IN", "BETWEEN", and "IS".
including "=", "==", "&lt;", "&lt;=", "&gt;", "&gt;=", "!=", "<>",
"IN", "NOT IN", "BETWEEN", "IS", and "IS NOT", .

<h3>3.1 Sort Order</h3>

<p>The results of a comparison depend on the storage classes of the
operands, according to the following rules:</p>
<ul>
  <li><p>^A value with storage class NULL is considered less than any