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: |
da19a96616243390e83fc42845aa0cda |
| 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
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>=-81.0 AND maxX<=-79.6
AND minY>=35.0 AND maxY>=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>=-81.0 AND maxX<=-79.6
AND minY>=35.0 AND maxY<=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
|