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

From madhtr
Subject Re: How to clear bits?
Date
Msg-id 00d101c7fbb1$76553fb0$7b55503f@useronewin2klt
Whole thread Raw
In response to Re: Tsearch2 - spanish  (marcelo Cortez <jmdc_marcelo@yahoo.com.ar>)
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


pgsql-general by date:

Previous
From: Sysadmin
Date:
Subject: Manually clearing "database "foo" is being accessed by other users"
Next
From: Tom Lane
Date:
Subject: Re: Manually clearing "database "foo" is being accessed by other users"