Re: How to clear bits?

nevermind, I figured it out ...

fails:

0xffffff00 &~ 0x0000ffff

succeeds:

0xffffff00 & ~ 0x0000ffff

I had to add a space.

----- Original Message -----
From: "madhtr" <madhtr(at)schif(dot)org>
To: "PostgreSQL General" <pgsql-general(at)postgresql(dot)org>
Sent: Thursday, September 20, 2007 13:01
Subject: [GENERAL] How to clear bits?

> Hello group :)
>
> How do a clear bits in a number in PostGreSQL?
>
> in c++ its:
>
> 0xffffff00 &~ 0x0000ffff
>
> what is it in PostGreSQL from the psql command line app?
>
> select ...
>
> Thanx:)
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match