On Sun, Nov 24, 2013 at 4:30 PM, Petite Abeille <petite.abei...@gmail.com>wrote:
> > On Nov 24, 2013, at 3:17 PM, Doug Currie <doug.cur...@gmail.com> wrote: > > > There is value in compatibility, but those adjectives are awful. > > FWIW, DETERMINISTIC is what Oracle uses: > > > http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/function.htm#LNPLS1183 > There's also this: http://docs.oracle.com/cd/B13789_01/appdev.101/b10807/13_elems039.htm that specifies various levels of "purity", i.e. if the package function reads from or writes to the database or global state. Each level allows for more aggressive optimization when the function takes part in a query. It's been a while since I've coded in PL/SQL but I think that if the RESTRICT_REFERENCES pragma is not specified for a package function the SQL engine will not accept calls to it from an SQL statement. Also, if the implementation of a function violates its RESTRICT_REFERENCES pragma the PL/SQL compiler will not compile it. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
