Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix a coordinate error in the RTree documentation. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
600d42757398854cfad3d61f30e5488e |
| User & Date: | drh 2013-04-17 13:35:14 |
Context
|
2013-04-19
| ||
| 02:30 | Enhancements to the run-time loadable extensions documentation. check-in: 9d4141b91f user: drh tags: trunk | |
|
2013-04-17
| ||
| 13:35 | Fix a coordinate error in the RTree documentation. check-in: 600d427573 user: drh tags: trunk | |
| 12:58 | Add a documentation page describing how to write run-time loadable extensions. check-in: 6da9f893bc user: drh tags: trunk | |
Changes
Changes to pages/rtree.in.
124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 |
^The usual [INSERT], [UPDATE], and [DELETE] commands work on an R*Tree
index just like on regular tables. ^(So to insert some data into our sample
R*Tree index, we can do something like this:
</p>
<blockquote><pre>
INSERT INTO demo_index VALUES(
1, -- Primary key
-80.7749, -80.7747, -- Longitude range
33.3776, 35.3778 -- Latitude range
);
INSERT INTO demo_index VALUES(
2,
-81.0, -79.6,
35.0, 36.2
);
</pre></blockquote>)^
<p>
The entries above might represent (for example) a bounding box around
|
| | | |
124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 |
^The usual [INSERT], [UPDATE], and [DELETE] commands work on an R*Tree
index just like on regular tables. ^(So to insert some data into our sample
R*Tree index, we can do something like this:
</p>
<blockquote><pre>
INSERT INTO demo_index VALUES(
1, -- Primary key -- SQLite.org headquarters
-80.7749, -80.7747, -- Longitude range
35.3776, 35.3778 -- Latitude range
);
INSERT INTO demo_index VALUES(
2, -- NC 12th Congressional Distrinct in 2010
-81.0, -79.6,
35.0, 36.2
);
</pre></blockquote>)^
<p>
The entries above might represent (for example) a bounding box around
|