Re: [sqlite] Custom SQL functions and "nullvalue"

2012-10-03 Thread Duquette, William H (318K)
On 10/3/12 4:20 AM, "Richard Hipp" wrote: >On Tue, Oct 2, 2012 at 5:12 PM, Duquette, William H (318K) < >william.h.duque...@jpl.nasa.gov> wrote: > >> Howdy! >> >> The SQLite3 Tcl interface has a "nullvalue" command, which determines >>how >> NULLs are represented as Tcl values. If you do a quer

Re: [sqlite] Custom SQL functions and "nullvalue"

2012-10-03 Thread Richard Hipp
On Tue, Oct 2, 2012 at 5:12 PM, Duquette, William H (318K) < william.h.duque...@jpl.nasa.gov> wrote: > Howdy! > > The SQLite3 Tcl interface has a "nullvalue" command, which determines how > NULLs are represented as Tcl values. If you do a query on a NULL value, > you get the "nullvalue" value. (

[sqlite] Custom SQL functions and "nullvalue"

2012-10-02 Thread Duquette, William H (318K)
Howdy! The SQLite3 Tcl interface has a "nullvalue" command, which determines how NULLs are represented as Tcl values. If you do a query on a NULL value, you get the "nullvalue" value. ("nullvalue" defaults to the empty string.) However, if a NULL value is passed to a custom SQL function, defi

Re: [sqlite] custom sql functions

2008-02-08 Thread Dennis Cote
Nathan Biggs wrote: > Does anyone know where there is information on adding custom functions > to sqlite? I have been using the CreateAggregate function to define my > custom function, but just wanted to see if it was faster by re-compiling > sqlite with the function in it already. I have the

[sqlite] custom sql functions

2008-02-08 Thread Nathan Biggs
Does anyone know where there is information on adding custom functions to sqlite? I have been using the CreateAggregate function to define my custom function, but just wanted to see if it was faster by re-compiling sqlite with the function in it already. I have the sqlite source code and have