Bitwise operation

From: "Rudi Starcevic" <rudi(at)oasis(dot)net(dot)au>
To: pgsql-sql(at)postgresql(dot)org
Subject: Bitwise operation
Date: 2003-06-30 12:28:15
Message-ID: 20030630122815.M76087@oasis.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


Hi,

I'm learning to use Postgresql's bitwise operator's as I'm interested
in building super fast search's based on user selections in web forms.

So far so good but I have just lost it a little so I thought I'd post.
Please growl at me if I'm asking on the wrong list :-)

I understand this:

SELECT 111 & 11 = 11

but not this

SELECT 1111 & 111 = 71

I was expecting the second example to be

SELECT 1111 & 111 = 111

Hmm ...

Maybe I should search on the web for some more info on how to
understand this logic.
Math was never my strongest I was always better at creative writing.

Any advice much appreciated.
Thanks
Best Regards
Rudi.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Hubert Lubaczewski 2003-06-30 12:36:31 Re: Bitwise operation
Previous Message scott.marlowe 2003-06-30 12:06:25 Re: need some help with a delete statement