Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix a bug in the R-Tree documentation. (CVS 5186) |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
bb445a4b1fe43d7b3e8546a6510f4e3c |
| User & Date: | drh 2008-06-04 14:20:09 |
Context
|
2008-06-04
| ||
| 15:09 | Fix another typo in the rtree README file. (CVS 5187) check-in: 9ab87b7b user: drh tags: trunk | |
| 14:20 | Fix a bug in the R-Tree documentation. (CVS 5186) check-in: bb445a4b user: drh tags: trunk | |
| 06:45 | Add "pragma journal_size_limit", used to limit the space consumed by persistent journal files left in the file-system after a transaction has concluded in exclusive (or journal_mode=persist) mode. (CVS 5185) check-in: 5c59f469 user: danielk1977 tags: trunk | |
Changes
Changes to ext/rtree/README.
31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 |
constructed using the following syntax:
CREATE VIRTUAL TABLE <name> USING rtree(<column-names>)
For example:
CREATE VIRTUAL TABLE boxes USING rtree(boxno, xmin, xmax, ymin, ymax);
CREATE VIRTUAL TABLE boxes USING rtree(1, 1.0, 3.0, 2.0, 4.0);
Constructing a virtual r-tree table <name> creates the following three
real tables in the database to store the data structure:
<name>_node
<name>_rowid
<name>_parent
|
| |
31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 |
constructed using the following syntax:
CREATE VIRTUAL TABLE <name> USING rtree(<column-names>)
For example:
CREATE VIRTUAL TABLE boxes USING rtree(boxno, xmin, xmax, ymin, ymax);
INSERT INTO boxes VALUES(1, 1.0, 3.0, 2.0, 4.0);
Constructing a virtual r-tree table <name> creates the following three
real tables in the database to store the data structure:
<name>_node
<name>_rowid
<name>_parent
|