Re: How to clear bits?

["madhtr" <madhtr@xxxxxxxxx>]

nevermind, I figured it out ...

fails:

0xffffff00 &~ 0x0000ffff

succeeds:

0xffffff00 & ~ 0x0000ffff

I had to add a space.




----- Original Message ----- 
From: "madhtr" <madhtr@xxxxxxxxx>
To: "PostgreSQL General" <pgsql-general@xxxxxxxxxxxxxx>
Sent: Thursday, September 20, 2007 13:01
Subject:  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


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org/