On 23.11.2013 13:18, Richard Hipp wrote:
SQLite must know that the function always gives the same output given the same inputs. No every function works that way. Counterexamples include random() and last_insert_rowid(). But most built-in functions are factorable in the same way that datetime() is.
BTW, I see the term "deterministic" in the SQL99 BNFs: http://savage.net.au/SQL/sql-99.bnf.html#deterministic%20characteristic http://savage.net.au/SQL/sql-2003-2.bnf.html#deterministic%20characteristic aslo found in MySQL: http://dev.mysql.com/doc/refman/5.6/en/create-procedure.html but different in PostgreSQL ("immutable", "stable", etc): http://www.postgresql.org/docs/9.3/static/sql-createfunction.html I think "deterministic" is used also in the Prolog, whit the same meaning. Kind Regards, Alek _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users