Re: [sqlite] sin and similar functions

man <[EMAIL PROTECTED]> > To: sqlite-users@sqlite.org > Sent: Friday, March 9, 2007 3:00:22 PM > Subject: Re: [sqlite] sin and similar functions > > Thank you very much. > Not only my english is poor, but my coordinated geometry too :-( > But my software will make much more geom

Re: [sqlite] sin and similar functions

-archive.com/sqlite-users@sqlite.org/msg21791.html > > -Clark > > - Original Message > From: Jakub Ladman <[EMAIL PROTECTED]> > To: sqlite-users@sqlite.org > Sent: Friday, March 9, 2007 3:00:22 PM > Subject: Re: [sqlite] sin and similar functions > > Tha

Re: [sqlite] sin and similar functions

Jakub Ladman wrote: Thank you very much. Not only my english is poor, but my coordinated geometry too :-( But my software will make much more geometrical computations, so probably some in queries too. Please let You (or someone) direct me to the relevant part of documentation for defining new f

Re: [sqlite] sin and similar functions

org Sent: Friday, March 9, 2007 3:00:22 PM Subject: Re: [sqlite] sin and similar functions Thank you very much. Not only my english is poor, but my coordinated geometry too :-( But my software will make much more geometrical computations, so probably some in queries too. Please let You (or someo

Re: [sqlite] sin and similar functions

I could copy the example from the Sqlite documentation or you could just look it up in the API description. You write your function, in this case only a few lines of code, and bind it to Sqlite using the API. http://www.sqlite.org/capi3ref.html sqlite3_create_function Jakub Ladman wrote: But

Re: [sqlite] sin and similar functions

Jakub, The documentation for creating user-defined functions is at . See section 2.3. Unfortunately, I don't know the A,B of C, so I can't guide you in this. On the other hand, if you are using Perl, I can write you a step-by-step process for creating your own fu

Re: [sqlite] sin and similar functions

Thank you very much. Not only my english is poor, but my coordinated geometry too :-( But my software will make much more geometrical computations, so probably some in queries too. Please let You (or someone) direct me to the relevant part of documentation for defining new functions. Thank You J

Re: [sqlite] sin and similar functions

But the question was "how" Probably i am asking time after time stupid questions only - It is because my english is not half good to orientate oneself easily in the documentation, so quick summary in someones answer makes more than hours of reading docs. Usualy i am asking if i understand not to

Re: [sqlite] sin and similar functions

Jakub Ladman wrote: I will have table with sequence of coordinates (two dimensional space) and corresponding radiuses, so sequence of circles. And i need to use a sqlite query to detect if a actual coordinates (after their measurement) match some of the circle's square or not. And which circle,

Re: [sqlite] sin and similar functions

Just add a sine function in the normal manner of adding a function. It is very simple. Jakub Ladman wrote: Hi Friends Is there a possibility to have sin cos an acos, functions in sqlite? How to write it in? I really need it and i have fear, that sinus values table will be so slow and so big

Re: [sqlite] sin and similar functions

I am sorry, it seems to be unreadable bacause of my very bad english. I try to correct it little bit. Hi Friends :-) Is there a possibility to have sin, cos anD acos, functions in sqlite? How to write it in? I have read (Mike Owens article at LinuxJournal), that it is possible to write new funct

[sqlite] sin and similar functions

Hi Friends Is there a possibility to have sin cos an acos, functions in sqlite? How to write it in? I really need it and i have fear, that sinus values table will be so slow and so big for critical precission. I will need to select coordinates which are laying in circle of known center and radi