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

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