Re: binary operators on integers
От | Peter Eisentraut |
---|---|
Тема | Re: binary operators on integers |
Дата | |
Msg-id | Pine.LNX.4.21.0009182216050.380-100000@peter обсуждение исходный текст |
Ответ на | binary operators on integers (Marko Kreen <marko@l-t.ee>) |
Ответы |
Re: binary operators on integers
|
Список | pgsql-general |
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/
В списке pgsql-general по дате отправления: