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 a boundary and 2 where the point is inside of the boundary. While the documentation is technically correct, (for a suitable definition of “true” differing from its meaning in SQL), this seems to be a useful behavior worthy of exposure.
I suggest the rewording, “returns 2 if the coordinate X,Y is inside polygon P, 1 if on the boundary, or 0 otherwise.” I submit that this might help avoid errors such as “… WHERE geopoly_contains_point(_shape, ptX, ptY) = TRUE”, which will produce surprise for those who read the present claim literally. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
