Re: [HACKERS] Re: [GENERAL] Update of bitmask type

From: Adriaan Joubert <a(dot)joubert(at)albourne(dot)com>
To: The Hermit Hacker <scrappy(at)hub(dot)org>
Cc: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>, PostgreSQL-hackers <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: [HACKERS] Re: [GENERAL] Update of bitmask type
Date: 1999-09-22 06:20:50
Message-ID: 37E87542.2F8ADA4A@albourne.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

The Hermit Hacker wrote:
>
> On Tue, 21 Sep 1999, Bruce Momjian wrote:
>
> > Can I get comments on this? Is a bit type something we want installed
> > by default, or in contrib? Seems to me it should be in the main tree.
>
> first...what is a bitmask type? :)

In this case just a single byte in which you can store states quite
easily. It supports the C-style bit operations & (and) ,| (or, couldn't
get it defined as a single bar though, because the parser didn't like
it) ,^ (xor),! (not). For some applications it is just easier to check
whether certain bits are set/not set.

If somebody tells me what needs doing, I could try to get it all into a
more usable format. And I have no clue what SQL3 says about bit-types
(varying bits or something or other?) At the moment it is just a single
byte, and perhaps it needs extension to 2 byte, 4-byte types.

Adriaan

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jelle Ruttenberg 1999-09-22 07:12:25 Q: Mac: Openlink->Linux: Openlink-PostgreSQL
Previous Message omid omoomi 1999-09-22 06:01:10 Re: [GENERAL] when are indexes used?

Browse pgsql-hackers by date

  From Date Subject
Next Message Billy G. Allie 1999-09-22 07:29:48 Re: [HACKERS] Status on Jan Wieck
Previous Message The Hermit Hacker 1999-09-22 05:46:46 Re: [HACKERS] Re: [GENERAL] Update of bitmask type