Re: [sqlite] User functions

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

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

[sqlite] User functions

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

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