Mats Sjöberg <mats.sjoberg@cybernetics.se> writes:
> What is the syntax to extract those bits?
At least in 7.4, you can do it the same way you'd do it in C:
regression=# select ((47::bigint) >> 3) & 1;?column?
---------- 1
(1 row)
I'm not sure when the bigint >> and & operators got added, but \do would
tell you quickly enough if they're in your version.
Mind you that this is not going to be an especially fast solution, since
these are not indexable operators. You might be better advised to
rethink your data representation.
regards, tom lane