Documentation Source Text: Check-in [a43ee1e871]

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:	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