Documentation Source Text

Check-in [838bd2b455]
Login

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

Overview
Comment:Add <> to the list of comparison operators in datatype3.html.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 838bd2b455e97ab423269540bc507d80a07f1404
User & Date: drh 2010-09-14 13:25:19.000
Context
2010-09-14
18:57
Fix a recently introduced error regarding collation sequences and compounds SELECT statements. (check-in: 8d9fe20890 user: dan tags: trunk)
13:25
Add <> to the list of comparison operators in datatype3.html. (check-in: 838bd2b455 user: drh tags: trunk)
2010-09-13
18:56
Changes to SELECT documentation related to compound SELECT operators. (check-in: 182ba19363 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

</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
︙︙