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
Unified Diff Ignore Whitespace Patch
Changes to pages/datatype3.in.
301
302
303
304
305
306
307
308

309
310
311
312
313
314
315
</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".


<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







|
>







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;", "&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