Thread: int/bit fields

int/bit fields

From
Sascha Schumann
Date:
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