Re: Bitwise operators in SQL

Peter Eisentraut <peter_e@gmx.net> writes:

> Arcady Genkin writes:
>
> > But the problem is that there are no
> > bitwise operators among Postgres's supported operators.  So, I cannot
> > write something like
> >
> > select name from pages where access&2>0;
> >
> > Is there a standard way to approach this kind of problem?
>
> Upgrading.

Indeed, thanks.  I was reading the docs for 7.0, and didn't notice
that 7.1 has bitwise operators.

Thanks a lot,
--
Arcady Genkin