Documentation Source Text

Check-in [da19a96616]
Login

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

Overview
Comment:Fix a minor typo in the rtree documentation.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: da19a96616243390e83fc42845aa0cda6a0b90f71eb474aafdd9c31387c78ffa
User & Date: drh 2020-05-18 14:36:48
Context
2020-05-19
12:37
Update the speed and size charts. check-in: 386621474b user: drh tags: trunk
2020-05-18
14:37
Fix a minor typo in the rtree documentation. check-in: f073620ff2 user: drh tags: branch-3.31
14:36
Fix a minor typo in the rtree documentation. check-in: da19a96616 user: drh tags: trunk
2020-05-16
00:12
Merge the branch-3.31 changes into trunk. check-in: 2f7a35660e user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/rtree.in.

374
375
376
377
378
379
380
381
382
383
384
385
386
387
388

<a name="diquery"></a>
<codeblock>
SELECT objname FROM demo_data, demo_index
 WHERE demo_data.id=demo_index.id
   AND contained_in(demo_data.boundary, :boundary)
   AND minX&gt;=-81.0 AND maxX&lt;=-79.6
   AND minY&gt;=35.0 AND maxY&gt;=36.2;
</codeblock>

<p>In the query above, one would presumably bind the binary BLOB 
description of the precise boundary of the 12th district to the
":boundary" parameter.</p>

<p>Notice how the query above works:  The R*Tree index runs in the outer







|







374
375
376
377
378
379
380
381
382
383
384
385
386
387
388

<a name="diquery"></a>
<codeblock>
SELECT objname FROM demo_data, demo_index
 WHERE demo_data.id=demo_index.id
   AND contained_in(demo_data.boundary, :boundary)
   AND minX&gt;=-81.0 AND maxX&lt;=-79.6
   AND minY&gt;=35.0 AND maxY&lt;=36.2;
</codeblock>

<p>In the query above, one would presumably bind the binary BLOB 
description of the precise boundary of the 12th district to the
":boundary" parameter.</p>

<p>Notice how the query above works:  The R*Tree index runs in the outer