Skip to content

Instantly share code, notes, and snippets.

@simonw

simonw/view-functions.sql Secret

Created March 20, 2024 23:14
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save simonw/c6fa2d722e7599f3874f27cb19fc8fe4 to your computer and use it in GitHub Desktop.
Save simonw/c6fa2d722e7599f3874f27cb19fc8fe4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
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();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment