SELECT DISTINCT name FROM pragma_function_list --WHERE (flags & 0x200000)!=0 -- no such column: flags ORDER BY name;
Works if I drop the WHERE. Is there a special compile flag that must be used? On Fri, Jan 24, 2020 at 5:42 PM Brian Curley <bpcur...@gmail.com> wrote: > separate but somewhat related question, based on the response: > > Has any thought been given to updating the documentation to cover those > pragmas that have been upgraded to selectable entities? > > I've only been able to find a handful of references along the way, such as > pragma_table_info, pragma_index_info, and the aforementioned > pragma_function_list, at least that I recall. Any sort of listing of what's > available like these? > > I'd think that it would be helpful in the peanut gallery. Thanks! > > Regards. > > Brian P Curley > > > > On Fri, Jan 24, 2020 at 4:12 PM Richard Hipp <d...@sqlite.org> wrote: > > > SELECT DISTINCT name > > FROM pragma_function_list > > WHERE (flags & 0x200000)!=0 > > ORDER BY name; > > > > On 1/24/20, Peter Kolbus <peter.kol...@gmail.com> wrote: > > > Is there any documentation showing, or an easy way to generate, the > exact > > > list of SQLite-provided functions that are innocuous? > > > > > > I’d like to turn on the new SQLITE_TRUSTED_SCHEMA but support a variety > > of > > > applications and am hoping for something to guide analysis. > > > > > > Thanks > > > -Peter > > > _______________________________________________ > > > sqlite-users mailing list > > > sqlite-users@mailinglists.sqlite.org > > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > > > > > > -- > > D. Richard Hipp > > d...@sqlite.org > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users