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