On Tue, 3 Dec 2013 11:29:03 -0800 Scott Hess <sh...@google.com> wrote:
> Probably we should add a new API that allows the application > > to state auxiliary properties about application-defined functions > > (such as whether or not it is "constant", whether or not it can > > return NULL, whether or not it might change the encoding of its > > input parameters, etc.) But that has not been done yet. > > > IMHO, the default should be that a given function with given > parameters should be assumed to return a single value which is good > across the entire statement [...]. > > That said, I'm a little nervous about having that be an attribute of > the function rather than the statement. Why nervous? Determinism is a property of a function; there is no such thing as a function that is sometimes deterministic and sometimes not. --jkl _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users