Re: Bitwise operators in SQL - Mailing list pgsql-general

From Arcady Genkin
Subject Re: Bitwise operators in SQL
Date
Msg-id r1zeltdqiqg.fsf@gnu.cdf.toronto.edu
Whole thread Raw
In response to Re: Bitwise operators in SQL  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Feite Brekeveld
Date:
Subject: Re: pl-perl setup?
Next
From: Jeff Boes
Date:
Subject: Re: pl-perl setup?