Bruno,Hubert,
Thanks.
It's all crystal clear now.
Now I can keep moving on with my app.
If all goes well I hope to add a 'techdoc' on how to do this.
I've found documents from other DBMS on using Bitwise operations
but not PG.
Cheers
Rudi.
Bruno Wolff III wrote:
On Mon, Jun 30, 2003 at
On Mon, Jun 30, 2003 at 22:28:15 +1000,
Rudi Starcevic <[EMAIL PROTECTED]> wrote:
>
> 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
On Mon, 30 Jun 2003 22:28:15 +1000
"Rudi Starcevic" <[EMAIL PROTECTED]> wrote:
> SELECT & 111 = 71
> I was expecting the second example to be
> SELECT & 111 = 111
hmm ..:
let's see:
dec() is bin(10001010111)
dec(111) is bin(110)
so, when we'll "AND" them:
: 10001010
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:
SELE
