nevermind, I figured it out ...
fails:
0xffffff00 &~ 0x0000ffff
succeeds:
0xffffff00 & ~ 0x0000ffff
I had to add a space.
----- Original Message -----
From: "madhtr" <[EMAIL PROTECTED]>
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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
