Boolean and Bit

From: Keith Gray <keith(at)heart(dot)com(dot)au>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Boolean and Bit
Date: 2001-01-17 01:29:28
Message-ID: 3A64F578.2D7E7B84@heart.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert E. Bruccoleri 2001-01-17 01:48:10 Re: Performance degradation in PostgreSQL 7.1beta3 vs 6.5.3
Previous Message The Hermit Hacker 2001-01-17 01:22:42 Re: CASE inet << inet ...