If I'm redefining a user-defined function as SQLITE_DETERMINISTIC before each
query, will the function still get called for subsequent queries? For example,
if I had
void user_func(sqlite3_context *context, int argc, sqlite3_value **argv){
return random() }
sqlite3_create_function(db, "user", 1, SQLITE_UTF8 | SQLITE_DETERMINISTIC,
NULL, &user_func, NULL, NULL))
> select user()
.54
sqlite3_create_function(db, "user", 1, SQLITE_UTF8 | SQLITE_DETERMINISTIC,
NULL, &user_func, NULL, NULL))
> select user()
.54 <-- should this result be the same as the previous call to user()? Or
would it get evaluated once after each sqlite3_create_function() call?
----------------------------------------------------------------------
This message, and any attachments, is for the intended recipient(s) only, may
contain information that is privileged, confidential and/or proprietary and
subject to important terms and conditions available at
http://www.bankofamerica.com/emaildisclaimer. If you are not the intended
recipient, please delete this message.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
