Documentation Source Text

Check-in [3b812913fe]
Login

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

Overview
Comment:Fix a formatting error in the rtree.html document.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | branch-3.25
Files: files | file ages | folders
SHA3-256: 3b812913fe6006192a56278e24038de77df0224c90a75d3059eef9bde2bf6197
User & Date: drh 2018-09-26 19:52:47.943
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
Unified Diff Ignore Whitespace Patch
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>