Re: [sqlite] New SQL Function.

2004-08-19 Thread Federico Granata
Alle 20:04, mercoledì 18 agosto 2004, Doug Currie ha scritto: You must link with a math library that includes sqrt. Perhaps adding -lm (assuming you have libm.a and it has sqrt) to the end of the TCC or LTLINK lines in the Makefile will help. Thanks, now it's ok. -- Email.it, the

[sqlite] New SQL Function.

2004-08-18 Thread Federico Granata
Sorry for my english. I try to add a new SQL function (sqrt) as described at http://www.hwaci.com/sw/sqlite/c_interface.html#cfunc If I try (for understanding pourpose only) to return the same value I give to the function it's all ok, then (for a little experiment) I try to return the abs and

Re: [sqlite] New SQL Function.

2004-08-18 Thread Doug Currie
Wednesday, August 18, 2004, 1:45:43 PM, Federico wrote: [...] gcc -g -O2 -DTHREADSAFE=1 -DOS_UNIX=1 -DOS_WIN=0 -DHAVE_USLEEP=1 -I. -I../sqlite/src -DHAVE_READLINE=0 -o .libs/sqlite ../sqlite/src/shell.c ./.libs/libsqlite.so ./.libs/libsqlite.so: undefined reference to `sqrt' collect2:

Re: [sqlite] New SQL Function.

2004-08-18 Thread Raymond Irving
Is there some form of documentation that should all the functions allowed inside an SQL statement? For example: DATE(), CASE, etc __ Raymond Irving --- Doug Currie [EMAIL PROTECTED] wrote: Wednesday, August 18, 2004, 1:45:43 PM, Federico wrote: [...] gcc -g -O2 -DTHREADSAFE=1