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

• branch=trunk inherited from [b2e03e19ab]
• sym-trunk inherited from [b2e03e19ab]

Changes to pages/rtree.in

  126  R*Tree index, we can do something like this:                                         126  R*Tree index, we can do something like this:
  127  </p>                                                                                 127  </p>
  128                                                                                       128  
  129  <blockquote><pre>                                                                    129  <blockquote><pre>
  130  INSERT INTO demo_index VALUES(                                                       130  INSERT INTO demo_index VALUES(
  131      1,                   -- Primary key                                              131      1,                   -- Primary key
  132      -80.7749, -80.7747,  -- Longitude range                                          132      -80.7749, -80.7747,  -- Longitude range
  133      30.3776, 30.3778     -- Latitude range                                       |   133      33.3776, 35.3778     -- Latitude range
  134  );                                                                                   134  );
  135  INSERT INTO demo_index VALUES(                                                       135  INSERT INTO demo_index VALUES(
  136      2,                                                                               136      2,
  137      -81.0, -79.6,                                                                    137      -81.0, -79.6,
  138      35.0, 36.2                                                                       138      35.0, 36.2
  139  );                                                                                   139  );
  140  </pre></blockquote>)^                                                                140  </pre></blockquote>)^
  141                                                                                       141  
  142  <p>                                                                                  142  <p>
  143  The entries above might represent (for example) a bounding box around                143  The entries above might represent (for example) a bounding box around
  144  the offices for SQLite.org and bounding box around the                           |   144  the main office for SQLite.org and bounding box around the
  145  12th Congressional District of North Carolina in which SQLite.org is located.    |   145  12th Congressional District of North Carolina (prior to the 2011
                                                                                        >   146  redistricting) in which SQLite.org was located.
  146  </p>                                                                                 147  </p>
  147                                                                                       148  
  148  <h3>3.3 Querying An R*Tree Index</h3>                                                149  <h3>3.3 Querying An R*Tree Index</h3>
  149                                                                                       150  
  150  <p>                                                                                  151  <p>
  151  ^Any valid query will work against an R*Tree index.  But the R*Tree                  152  ^Any valid query will work against an R*Tree index.  But the R*Tree
  152  implementation is designed to make two kinds of queries especially                   153  implementation is designed to make two kinds of queries especially