Re: [sqlite] Implementing a CREATE_FUNCTION function

2010-05-05 Thread Igor Tandetnik
Dan Bishop wrote: > It's convenient to be able to define new functions in C. But sometimes, > it would be *more* convenient to be able to define new functions in > SQL. This could be done by registering a CREATE_FUNCTION() function; > then you could write something like: > > SELECT

[sqlite] Implementing a CREATE_FUNCTION function

2010-05-04 Thread Dan Bishop
It's convenient to be able to define new functions in C. But sometimes, it would be *more* convenient to be able to define new functions in SQL. This could be done by registering a CREATE_FUNCTION() function; then you could write something like: SELECT CREATE_FUNCTION('LEFT', 2, 'SUBSTR(?1,