Re: How to clear bits? - Mailing list pgsql-general

nevermind, I figured it out ...

fails:

0xffffff00 &~ 0x0000ffff

succeeds:

0xffffff00 & ~ 0x0000ffff

I had to add a space.




----- Original Message -----
From: "madhtr" <madhtr@schif.org>
To: "PostgreSQL General" <pgsql-general@postgresql.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