Re: [sqlite] RTree Documentation Error?

Hi Richard, et al, I'm sorry that it's bad manners for me to raise an issue and then disappear, but I didn't get a chance to check the list till a few minutes ago... On 17/4/2013 9:36 PM, Richard Hipp wrote: On Wed, Apr 17, 2013 at 9:25 AM, Michael Black wrote:

Re: [sqlite] RTree Documentation Error?

It would also be nice if 3.3 showed the "expected output" too. Would be a bit easier for the beginner to ensure they are sane. Also would've prevented this GIGO error me thinkst. Michael Black ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] RTree Documentation Error?

On Wed, Apr 17, 2013 at 9:25 AM, Michael Black wrote: > Correct -- no results for the "real" 2nd query > I see. I ran two queries together in my script so what I thought was the 2nd query was really the 3rd. The SQLite HQ coordinates are fixed in

Re: [sqlite] RTree Documentation Error?

; WHERE minX>=-81.08 AND maxX<=-80.58 ...>AND minY>=35.00 AND maxY<=35.44; 1 sqlite> SELECT id FROM demo_index ...> WHERE maxY>=35.0 AND minY<=35.0; 2 -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]

Re: [sqlite] RTree Documentation Error?

On Wed, Apr 17, 2013 at 8:41 AM, Michael Black wrote: > I think the point is that this query that produces nothing: > SELECT id FROM demo_index WHERE minX>=-81.08 AND maxX<=-80.58 AND > minY>=35.00 AND maxY<=35.44; > > Should produce something as the directions imply. >

Re: [sqlite] RTree Documentation Error?

I think the point is that this query that produces nothing: SELECT id FROM demo_index WHERE minX>=-81.08 AND maxX<=-80.58 AND minY>=35.00 AND maxY<=35.44; Should produce something as the directions imply. It's just that SQL HQ is not actually inside the city limits apparently (mailing addresses

Re: [sqlite] RTree Documentation Error?

On Wed, Apr 17, 2013 at 7:48 AM, Clemens Ladisch wrote: > Richard Hipp wrote: > > On Tue, Apr 16, 2013 at 1:15 PM, Mohit Sindhwani wrote: > >> Hi, I was looking at the RTree documentation page with one of my > >> colleagues -

Re: [sqlite] RTree Documentation Error?

Richard Hipp wrote: > On Tue, Apr 16, 2013 at 1:15 PM, Mohit Sindhwani wrote: >> Hi, I was looking at the RTree documentation page with one of my >> colleagues - >> >> We tried the example with the schema in 3.1, populated the data from 3.2 >>

Re: [sqlite] RTree Documentation Error?

On Tue, Apr 16, 2013 at 1:15 PM, Mohit Sindhwani wrote: > Hi, I was looking at the RTree documentation page with one of my > colleagues - > http://www.sqlite.org/rtree.**html > > We tried the example with the schema in 3.1, populated the data

[sqlite] RTree Documentation Error?

Hi, I was looking at the RTree documentation page with one of my colleagues - http://www.sqlite.org/rtree.html We tried the example with the schema in 3.1, populated the data from 3.2 and then queried it using the query of 3.3 - we got no results while the documentation says that "the query