view-functions.sql

create view functions as select *, case when flags & 0x800 != 0 then '1' else '0' end as 'deterministic', case when flags & 0x000100000 != 0 then '1' else '0' end as 'subtype', case when flags & 0x000200000 != 0 then '1' else '0' end as 'innocuous', case when flags & 0x000080000 != 0 then '1' else '0' end as 'directonly' from pragma_function_list();