Обсуждение: int/bit fields

Поиск
Список
Период
Сортировка

int/bit fields

От
Sascha Schumann
Дата:
Hi all,

we are in the progress of converting a flat ascii database to Postgres. In
the old database we used some int's to store bit fields which could be
easily used after parsing and converting them to numbers.

So, I need for example sth like this:

     SELECT * FROM mytable WHERE (statusbits & 8) <> 0

I had a quick look at the backend/utils/adt source directory, but didn't
found a function which provides such services. Where has the logic gone?

Any help appreciated.


         Sascha Schumann