On Thu, May 23, 2019 at 11:09 AM Keith Medcalf <kmedc...@dessus.com> wrote:
> >Keith, as can be seen below, those pragma_*list eponymous vtables are > >you referring to as not built-in. > > Actually they are. They are the eponymous vtables for the corresponding > pragma's: > > pragma function_list; > pragma collation_list; > pragma module_list; > C:\Users\ddevienne>sqlite3 SQLite version 3.28.0 2019-04-16 19:49:53 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> pragma function_list; sqlite> Now I recall... This is the "official" pre-built binaries from https://sqlite.org/download.html which does not turn ON these compile options. That's a shame IMHO. >I wasn't even aware one could get the function-list at all. Did you > >implement that as a pure extension w/o changing the official SQLite > >source code? Are all your extensions Open-Source, on GitHub or > somewhere? > > https://sqlite.org/pragma.html#pragma_function_list What's strange is that there's zero hit for the string "function_list" in https://www.sqlite.org/changes.html When was this introduced again? I also search for "information" and "schema", and failed to locate the ChangeLog entry. Even SQLITE_INTROSPECTION_PRAGMAS has no hit in this page in fact! Or instropection (instrospec does, but unrelated). Mysterious... --DD PS: Thanks for info on where to find your (own and collected) extensions. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
