Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Fix an error regarding operator precedence in fts5.html. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
a44bb1883372fd88bbbb054e7ca11d88 |
User & Date: | dan 2016-01-06 16:09:06.942 |
Context
2016-01-12
| ||
13:44 | Fix typos in the TCL interface documentation. (check-in: 217ea4895f user: drh tags: branch-3.10) | |
2016-01-11
| ||
13:00 | Begin entering 3.11.0 changes. (check-in: 166fc2da3a user: drh tags: trunk) | |
2016-01-06
| ||
16:09 | Fix an error regarding operator precedence in fts5.html. (check-in: a44bb18833 user: dan tags: trunk) | |
12:23 | Update download.in to look for products with version numbers starting with "31" instead of "30". (check-in: 55ba3b7506 user: dan tags: trunk) | |
Changes
Changes to pages/fts5.in.
︙ | ︙ | |||
310 311 312 313 314 315 316 | ... MATCH '{col1 col2} : NEAR("one two" "three four", 10)' ... MATCH '{col2 col1 col3} : one + two + three' </codeblock> <p> Phrases and NEAR groups may be arranged into expressions using <b>boolean | | | > > > > < < < | 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 | ... MATCH '{col1 col2} : NEAR("one two" "three four", 10)' ... MATCH '{col2 col1 col3} : one + two + three' </codeblock> <p> Phrases and NEAR groups may be arranged into expressions using <b>boolean operators</b>. In order of precedence, from highest (tightest grouping) to lowest (loosest grouping), the operators are: <table striped=1> <tr><th>Operator <th>Function <tr><td><code><query1> NOT <query2></code> <td>Matches if query1 matches and query2 does not match. <tr><td><code><query1> AND <query2></code> <td>Matches if both query1 and query2 match. <tr><td><code><query1> OR <query2></code> <td>Matches if either query1 or query2 match. </table> <p> Parenthesis may be used to group expressions in order to modify operator precedence in the usual ways. For example: <codeblock> |
︙ | ︙ |