bitwise logical operators

Started by Maurice Balickabout 25 years ago3 messagesgeneral
Jump to latest
#1Maurice Balick
balm@smiley.com

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

#2KuroiNeko
evpopkov@carrier.kiev.ua
In reply to: Maurice Balick (#1)
Re: bitwise logical operators

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

--

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

#3Peter Eisentraut
peter_e@gmx.net
In reply to: Maurice Balick (#1)
Re: bitwise logical operators

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/