Boolean and Bit - Mailing list pgsql-hackers

From Keith Gray
Subject Boolean and Bit
Date
Msg-id 3A64F578.2D7E7B84@heart.com.au
Whole thread Raw
List pgsql-hackers
Hello All,

This is my first post (so be gentle with me)...

Is there a searchable archive?

I would like suggestions and examples of adding SQL-92
data type BIT compatibility to a PostgreSQL schema.

From the doc's I gather you can "CREATE TYPE bit"
with storage int or int4... but I don't know
about the input/output for zero and one.

Should SQL (ODBC) be able to ask "WHERE bitfield;"
or should it ask "WHERE bitfield = 1;" ?

Any response gratefully recognized...




Keith


pgsql-hackers by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: CASE inet << inet ...
Next
From: bruc@stone.congenomics.com (Robert E. Bruccoleri)
Date:
Subject: Re: Performance degradation in PostgreSQL 7.1beta3 vs 6.5.3