Ivan Voras <[EMAIL PROTECTED]> writes:
> select * from tt where (flags & 16) != 0;
>
> I suspected radix trees could be used for this but it seems it doesn't work
> that way.
You would need a gist index method to make this work. I actually worked on one
for a while and had it working. But it was
Can indexes be used for bit-filtering queries? For example:
create table tt (
flags integer not null default 0,
str varchar
);
select * from tt where (flags & 16) != 0;
I suspected radix trees could be used for this but it seems it doesn't
work that way.
If not, is there a way of quick