Re: [sqlite] User functions

2005-02-23 Thread D. Richard Hipp
On Wed, 2005-02-23 at 17:35 -0700, Dennis Cote wrote: > Check the SQLite source file func.c in the zip file > http://www.sqlite.org/sqlite-source-3_1_3.zip. Also available by direct link at http://www.sqlite.org/cvstrac/getfile/sqlite/src/func.c -- D. Richard Hipp <[EMAIL PROTECTED]>

Re: [sqlite] User functions

2005-02-23 Thread Dennis Cote
Bob Dankert wrote: Is there a good example somewhere of how to implement user-defined functions? Bob, Check the SQLite source file func.c inthe zip file http://www.sqlite.org/sqlite-source-3_1_3.zip. It defines all the builtin functions in SQLite. It uses the same API you need to define custo

[sqlite] User functions

2005-02-23 Thread Bob Dankert
Is there a good example somewhere of how to implement user-defined functions? Thanks Bob Envision Information Technologies Associate [EMAIL PROTECTED] v. 608.256.5680 f. 608.256.3780

Re: [sqlite] User Functions / Graphs

2003-12-08 Thread Kurt Welgehausen
>> Is it http://citeseer.nj.nec.com/dong99maintaining.html ? Yes, that's it. Regards - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

RE: [sqlite] User Functions

2003-12-08 Thread Jarosław Nozderko
cember 05, 2003 10:41 PM > To: [EMAIL PROTECTED] > Subject: Re: [sqlite] User Functions > > > There's no good way to handle graphs in SQL. If you had a > tree, you could use Celko's nested-set scheme, but from your > description, you don't have a tree (unless you&

Re: [sqlite] User Functions

2003-12-05 Thread Kurt Welgehausen
There's no good way to handle graphs in SQL. If you had a tree, you could use Celko's nested-set scheme, but from your description, you don't have a tree (unless you're looking at it upside-down). Celko's book, _SQL for Smarties_, has a short chapter on handling non-tree graphs. Also there's a

Re: [sqlite] User Functions

2003-12-05 Thread Doug Currie
> [...] > I'm really lost on how to handle this parent->child relationship > using standard SQL. See > Trees in SQL > Joe Celko > 23 Feb 2001 > Rating: -4.52- (out of 5) Hall of fame tip of the month winner http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci537290,00.html Also see a thr

[sqlite] User Functions

2003-12-05 Thread David Horner
Hey everyone, New list member. I've been using sqlite for some time now and I'm very happy with the results. Very nice. Lately, I've been toying with the idea of creating user defined functions. I've successfully created simple functions that work as the functions provided in func.c work