Best bit fields implementation under postgres

Hello. I'm working on a database (postgresql) structure and some of the
tables in it
must store bit fields. Later on it must handle queries like "give me
all rows in this table that have bit N set to 1 AND bit M set to 0 AND
......". As far as i know i have several ways to inplement bit fields.

1. Using Bit String Types;
2. using plain integers
3. using arrays of boolean values
4. anything else?

What is the best way from the viewpoint of performance? Thanks

.

Relevant Pages

  • Re: Thank you with Design Assistance but...
    ... Although each Access database is limited to 2G, ... (StoreID in the sales table) ... You saw the simple queries that I ... Also how would I write the queries for, lets say, One Store, week ...
    (microsoft.public.access.tablesdbdesign)
  • Re: postgresql and binary data
    ... I have some postgresql database that stores binary data (windows/linux ... File in database, say, 4MB and user can download only first 175 kbyte ... is the best place to store data such as binaries. ...
    (comp.lang.php)
  • Re: How to setup STORE depository visible to the internet?
    ... This is a Microsoft Windows question more than a PostgreSQL or Smalltalk ... stop services (e.g. you are have an admin account). ... It owns the 'postgres database'. ... I use my own account as the store admin account. ...
    (comp.lang.smalltalk)
  • Re: Using stored procedures in C# for postgreSQL using ODBC
    ... queries for retriving data from database. ... I want to write queries using stored procedures, ... write stored procedures for postgreSQL. ... a full .NET provider, so you don't have to use the slower odbc route. ...
    (microsoft.public.dotnet.framework.adonet)
  • Using stored procedures in C# for postgreSQL using ODBC
    ... I am writing one simple application in C# in which i m writing some ... queries for retriving data from database. ... I want to write queries using stored procedures, ... write stored procedures for postgreSQL. ...
    (microsoft.public.dotnet.languages.vc)