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 | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
a43ee1e87137fae752e81ca1125c7e63 |
| User & Date: | drh 2010-09-14 19:10:08 |
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
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 "=", "<", "<=", ">=", "!=", "<>", "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 "=", "==", "<", "<=", ">", ">=", "!=", "<>",
"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
|