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@gmx.net http://yi.org/peter-e/