Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix a formatting error in the rtree.html document. |
|---|---|
| Timelines: | family | ancestors | descendants | both | branch-3.25 |
| Files: | files | file ages | folders |
| SHA3-256: | 3b812913fe6006192a56278e24038de7 |
| User & Date: | drh 2018-09-26 19:52:47 |
Context
|
2018-09-27
| ||
| 13:06 | Say that the recursive part of a CTE may not use aggregate or window functions. check-in: cf2f8cbd8f user: drh tags: branch-3.25 | |
|
2018-09-26
| ||
| 19:52 | Fix a formatting error in the rtree.html document. check-in: 3b812913fe user: drh tags: branch-3.25 | |
|
2018-09-25
| ||
| 19:32 | Version 3.25.2 check-in: 8c31c0cd8c user: drh tags: release, version-3.25.2, branch-3.25 | |
Changes
Changes to pages/rtree.in.
432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 |
<p>^(For example, a query like the following might be used to find all
R*Tree entries that overlap with a circle centered a 45.3,22.9 with a
radius of 5.0:
<codeblock>
SELECT id FROM demo_index WHERE id MATCH circle(45.3, 22.9, 5.0)
</blockquote></pre>)^
<p>^The SQL syntax for custom queries is the same regardless of which
interface, sqlite3_rtree_geometry_callback() or sqlite3_rtree_query_callback(),
is used to register the SQL function. However, the newer query-style
callbacks give the application greater control over how the query proceeds.
<h2>The Legacy xGeom Callback</h2>
|
| |
432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 |
<p>^(For example, a query like the following might be used to find all
R*Tree entries that overlap with a circle centered a 45.3,22.9 with a
radius of 5.0:
<codeblock>
SELECT id FROM demo_index WHERE id MATCH circle(45.3, 22.9, 5.0)
</codeblock>)^
<p>^The SQL syntax for custom queries is the same regardless of which
interface, sqlite3_rtree_geometry_callback() or sqlite3_rtree_query_callback(),
is used to register the SQL function. However, the newer query-style
callbacks give the application greater control over how the query proceeds.
<h2>The Legacy xGeom Callback</h2>
|