> On Sep 12, 2017, at 12:23 PM, Nelson, Erik - 2 > <erik.l.nel...@bankofamerica.com> wrote: > >> 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?
It gets evaluated whenever the SELECT runs. The value isn't cached anywhere. The only difference between a deterministic and a regular function currently (AFAIK) is that the former can be used in a CREATE INDEX statement. This allows a query that makes an equivalent call to use the index. TL;DR: it's how you can do efficient queries on derived values like JSON properties. —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users