Re: binary operators on integers

Marko Kreen writes:

> I want to do simple and/or/xor/test operations on integers
> but PostgreSQL seems not to support this. I found in conrib
> area the 'bit' package, which supports 'SQL-compliant bitstrings'
> but this is too weird for me and anyway it crashes too.

These were the remainders of a slightly too late implementation attempt
for 7.0. In 7.1 they should be fully functional.

> My situation: I want to implement a 'capabilities' field for
> application server, so different bits are for different
> capabilities.

Personally, I'd say using bit fields for that is pushing it a little too
hard. You could use shortint fields, or char(1)'s if you are not that
concerned about space.

--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/