| 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: | Whole Thread | Raw Message | 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.
| 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 |