Re: bit operations - Mailing list pgsql-general

From merlyn@stonehenge.com (Randal L. Schwartz)
Subject Re: bit operations
Date
Msg-id m1d77gzkn2.fsf@halfdome.holdit.com
Whole thread Raw
In response to Re: bit operations  (Oliver Vecernik <vecernik@aon.at>)
List pgsql-general
>>>>> "Oliver" == Oliver Vecernik <vecernik@aon.at> writes:

>> Say I wanna check if 8 (1xxx) and 2 (xx1x) is set, how do I do that?!

Oliver> Sorry, I didn't read the whole question first:

Oliver> select * from table where ((flags & 8) <> 0) and ((flags & 2) <> 0);

In the old days, we spelled that as flags & 10 = 10. :)  Wouldn't that
work just as well?

--
Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
<merlyn@stonehenge.com> <URL:http://www.stonehenge.com/merlyn/>
Perl/Unix/security consulting, Technical writing, Comedy, etc. etc.
See PerlTraining.Stonehenge.com for onsite and open-enrollment Perl training!

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: NOT IN issue
Next
From: Tom Lane
Date:
Subject: Re: Re: lo wrappers - still working on it