bitwise logical operators
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
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
--
������������������������������������
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/