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.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: a43ee1e87137fae752e81ca1125c7e63cbbe4114
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
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to pages/datatype3.in.

   301    301   </pre>
   302    302   </blockquote>)^
   303    303   
   304    304   <tcl>hd_fragment comparisons {comparison expressions}</tcl>
   305    305   <h2>3.0 Comparison Expressions</h2>
   306    306   
   307    307   <p>SQLite version 3 has the usual set of SQL comparison operators
   308         -including "=", "&lt;", "&lt;=", "&gt;=", "!=", "<>", "IN", "BETWEEN", and "IS".
          308  +including "=", "==", "&lt;", "&lt;=", "&gt;", "&gt;=", "!=", "<>",
          309  +"IN", "NOT IN", "BETWEEN", "IS", and "IS NOT", .
   309    310   
   310    311   <h3>3.1 Sort Order</h3>
   311    312   
   312    313   <p>The results of a comparison depend on the storage classes of the
   313    314   operands, according to the following rules:</p>
   314    315   <ul>
   315    316     <li><p>^A value with storage class NULL is considered less than any