Re: [sqlite] Question regarding guarantees of SQLITE_DETERMINISTIC

2014-02-17 Thread Stephan Beal
On Mon, Feb 17, 2014 at 6:23 PM, RSmith wrote: > The flag is telling SQLite that your function will behave > determinsitcally, i.e. it won't change the output for the same inputs > within a single query. > i figured so, just wanted to be sure. > SQLite then uses this

Re: [sqlite] Question regarding guarantees of SQLITE_DETERMINISTIC

2014-02-17 Thread RSmith
On 2014/02/17 18:47, Stephan Beal wrote: Hi, all, Regarding SQLITE_DETERMINISTIC: http://www.sqlite.org/c3ref/create_function.html does specifying that flag guaranty that sqlite3 will only call my "deterministic" function one time during any given SQL statement, or must my function actually

Re: [sqlite] Question regarding guarantees of SQLITE_DETERMINISTIC

2014-02-17 Thread Richard Hipp
On Mon, Feb 17, 2014 at 11:47 AM, Stephan Beal wrote: > Hi, all, > > Regarding SQLITE_DETERMINISTIC: > > http://www.sqlite.org/c3ref/create_function.html > > does specifying that flag guaranty that sqlite3 will only call my > "deterministic" function one time during any