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. (nullvalue

Re: [sqlite] Custom SQL functions and nullvalue

2012-10-03 Thread Duquette, William H (318K)
On 10/3/12 4:20 AM, Richard Hipp d...@sqlite.org 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 query

[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, defined