Re: [sqlite] geopoly_contains_point(P,X,Y) doc is overly modest

2018-12-01 Thread Graham Hardman
oh, I hope you dont do that since the application I am working on hopes to exploit the retval = 4 of geopoly_overlap ! regards, Graham On 02-12-2018 7:52 am, Richard Hipp wrote: On 12/1/18, Larry Brasfield wrote: The documentation at https://www.sqlite.org/geopoly.html , at 3.8. for geopoly_

Re: [sqlite] geopoly_contains_point(P,X,Y) doc is overly modest

2018-12-01 Thread Richard Hipp
On 12/1/18, Keith Medcalf wrote: > >>Maybe it should say 'Non-Zero' or 'Greater than Zero' rather than >>true, since true, as a symbol, as a special value. > > Yes and no, True and False is SQLite work as one would expect (assuming that > one is a programmer is a language that behaves as the under

Re: [sqlite] geopoly_contains_point(P,X,Y) doc is overly modest

2018-12-01 Thread Keith Medcalf
>Maybe it should say 'Non-Zero' or 'Greater than Zero' rather than >true, since true, as a symbol, as a special value. Yes and no, True and False is SQLite work as one would expect (assuming that one is a programmer is a language that behaves as the underlying hardware (CPU) behaves). The "Fal

Re: [sqlite] geopoly_contains_point(P,X,Y) doc is overly modest

2018-12-01 Thread Richard Damon
On 12/1/18 1:52 PM, Richard Hipp wrote: > On 12/1/18, Larry Brasfield wrote: >> The documentation at https://www.sqlite.org/geopoly.html , at 3.8. for >> geopoly_contains_point(), asserts that the function “returns true if and >> only if the coordinate X,Y is inside or on the boundary of the polyg

Re: [sqlite] geopoly_contains_point(P,X,Y) doc is overly modest

2018-12-01 Thread Richard Hipp
On 12/1/18, Larry Brasfield wrote: > The documentation at https://www.sqlite.org/geopoly.html , at 3.8. for > geopoly_contains_point(), asserts that the function “returns true if and > only if the coordinate X,Y is inside or on the boundary of the polygon P.” > As now implemented, in the v3.26 rel

[sqlite] geopoly_contains_point(P,X,Y) doc is overly modest

2018-12-01 Thread Larry Brasfield
The documentation at https://www.sqlite.org/geopoly.html , at 3.8. for geopoly_contains_point(), asserts that the function “returns true if and only if the coordinate X,Y is inside or on the boundary of the polygon P.” As now implemented, in the v3.26 release, it returns 1 where the point is on

Re: [sqlite] geopoly_contains_point

2018-09-13 Thread Richard Hipp
On 9/13/18, Jens Alfke wrote: > The geopoly docs says that only the geopoly_overlap(P1,P2) and > geopoly_within(P1,P2) functions are optimized to use the R-tree index when > used as a WHERE test; so that means the geopoly_contains_point function is > not. > > This implies that, if I want to query

[sqlite] geopoly_contains_point

2018-09-13 Thread Jens Alfke
The geopoly docs says that only the geopoly_overlap(P1,P2) and geopoly_within(P1,P2) functions are optimized to use the R-tree index when used as a WHERE test; so that means the geopoly_contains_point function is not. This implies that, if I want to query for polygons containing a given point, I