Re: [PERFORM] Bitmasks

2005-12-10 Thread Greg Stark
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

[PERFORM] Bitmasks

2005-12-10 Thread Ivan Voras
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