int/bit fields

From: Sascha Schumann <sas(at)schell(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: int/bit fields
Date: 1998-08-02 15:26:01
Message-ID: Pine.LNX.4.00.9808021714520.2949-100000@guerilla.foo.bar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Browse pgsql-sql by date

  From Date Subject
Next Message Roman Volkoff 1998-08-02 16:46:27 unsubscribe
Previous Message Peter T Mount 1998-08-01 22:48:30 Re: [ADMIN] Authentication Problems