Skip to content

Instantly share code, notes, and snippets.

@onexdrk

onexdrk/PGSQL bitmask select

Created September 5, 2013 11:37
Show Gist options
  • Save onexdrk/6449029 to your computer and use it in GitHub Desktop.
Save onexdrk/6449029 to your computer and use it in GitHub Desktop.
Download ZIP
PGSQL bitmask select
Raw
PGSQL bitmask select
select * from aaa where ((rubrics::bit(40)::bit varying(40) & B'0000000000000000000000000000000011'::bit(40)::bit varying(40)) > B'0'::bit(40)::bit varying(40) )
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment