> Simon Slavin wrote: > > On 6 Feb 2018, at 8:33am, Ulrich Telle wrote: > > > Another possibility would be to add a user-defined function for the > > configuration of the extension that could be called from a SELECT > > statement: > > > > SELECT myextension_config('param-name', 'param-value'); > > I've seen this done before. Of course it means that your normal function is > not deterministic, so you may no longer use SQLITE_DETERMINISTIC . This is > in contrast to a function where parameters are set during compilation.
Well, actually my goal is not to have an extension with non-deterministic functions. The parameters have mostly the purpose to initialize the extension (things similar to what you do to SQLite itself with pragmas like "PRAGMA cache_size", or "PRAGMA data_store_directory"). The extension would accept changes to the parameters only before the first invocation of the extension functions. Regards, Ulrich _______________________________________________ sqlite-users mailing list firstname.lastname@example.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users