Thread: bitwise logical operators

bitwise logical operators

From
Maurice Balick
Date:
Hello,

I've found one old request in the archives about providing bitwise AND
on integer types and nothing but the obvious 'modulo soup' answer.  I
couldn't find anything in the TODO list either.

Is there any plan to add bitwise logical operators to Postgres? Or is
there a good reason never to have it? Using 32 boolean columns instead
of a single integer flag set seems very expensive - especially when you
end up loading the flags into an integer on the client side.

A 20/80 solution in my case would be a function to perform bitwise AND
on two integers.

Thanks.

--Maurice



Re: bitwise logical operators

From
KuroiNeko
Date:
> A 20/80 solution in my case would be a function to perform bitwise AND
> on two integers.

 I've got  something like that.  Anyone interested  is welcome to  reach me
off-list.

 Ed


--

 ������������������


Re: bitwise logical operators

From
Peter Eisentraut
Date:
Maurice Balick writes:

> I've found one old request in the archives about providing bitwise AND
> on integer types and nothing but the obvious 'modulo soup' answer.  I
> couldn't find anything in the TODO list either.

Available in 7.1.

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/