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 guaranty that deterministic behaviour itself? The canonical example is a now() function which returns time(NULL) (there was a long thread on this topic a few months back). My concrete questions: - Does such function need to make the guaranty itself or is marking it as SQLITE_DETERMINISTIC enough to keep sqlite from calling it twice in one statement? - Can "within a single SQL statement" be interpreted as "within the lifetime of a given preparation of a given sqlite3_stmt handle" without distorting the truth too much, or is there a more complex definition involving subselects and such? -- ----- stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal "Freedom is sloppy. But since tyranny's the only guaranteed byproduct of those who insist on a perfect world, freedom will have to do." -- Bigby Wolf _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users