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

[sqlite] sqlite3_exec()

2018-12-01 Thread Prajeesh Prakash
Hi Team, Is this sqlite3_exec() function is a blocking call in the case of writing.I have two thread one is for reading and other is for writing the DB. Both thread have the same DB connection(Of course i am in FULLMUTEX mode and sqlite point of few there is no multiple thread every thing is

Re: [sqlite] sqlite3_exec()

2018-12-01 Thread Simon Slavin
On 1 Dec 2018, at 1:50pm, Prajeesh Prakash wrote: > I have two thread one is for reading and other is for writing the DB. Both > thread have the same DB connection One connection can only execute one operation at one time. If you want simultaneous operations, use two connections. Simon.

Re: [sqlite] function named geopolyCosine is a misnomer

2018-12-01 Thread John G
If I missed i tin earlier posts, sorry. Is there any documentation on the geopoly extension? With possible uses or examples? John On Thu, 29 Nov 2018 at 14:39, Richard Hipp wrote: > On 11/29/18, Thomas Kurz wrote: > > Could it be that the one angle is north-based, the other one east-based? >

Re: [sqlite] function named geopolyCosine is a misnomer

2018-12-01 Thread Richard Hipp
On 12/1/18, John G wrote: > Is there any documentation on the > geopoly extension? > https://www.sqlite.org/search?s=d=geopoly https://www.sqlite.org/geopoly.html -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list

[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

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

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

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

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

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

2018-12-01 Thread Keith Medcalf
On Saturday, 1 December, 2018 12:23, Richard Hipp wrote" >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

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

2018-12-01 Thread Keith Medcalf
Ok. This behaviour is documented here: https://www.sqlite.org/lang_expr.html#booleanexpr --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-Original Message- >From: sqlite-users [mailto:sqlite-users-