Documentation Source Text

Check-in [f073620ff2]
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 | branch-3.31
Files: files | file ages | folders
SHA3-256: f073620ff27f6c8d96078bd209d7c940167d22fecb11a6a616ec844b907a5677
User & Date: drh 2020-05-18 14:37:20
Context
2020-05-20
01:27
Fix the INSERT syntax diagram so that it is not possible to go from DEFAULT VALUES to the upsert-clause. check-in: 8b88f8f240 user: drh tags: branch-3.31
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:10
Remove the FAQ about the round() function. check-in: b064af7596 user: drh tags: branch-3.31
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