cast bit to boolean?

From: Vivek Khera <khera(at)kcilink(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: cast bit to boolean?
Date: 2001-05-03 21:25:14
Message-ID: 15089.52410.394758.491793@onceler.kciLink.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

How might one case a BIT to a BOOLEAN? For example, I want to return
rows which have non-zero bit representation for, say, (sel_a & b'0011').
That is, rows with the first or second bit set.

I tried an explicit CAST, and just the query directly, but the cast
say you cant cast type 'bit' to 'bool', and the direct query says
WHERE clause must return type bool, not type bit:

create table t1 (sel_a BIT(6),sel_b BIT(6));
insert into t1 values (b'000001',b'001000');
select * from t1 where sel_a & b'100001';
ERROR: WHERE clause must return type bool, not type bit

Where might I look for this? The manual is quite sparse regarding BIT
types.

Thanks.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joel Burton 2001-05-03 21:28:14 Re: mysql to Pgsql
Previous Message Tom Lane 2001-05-03 21:24:37 Re: View permissions in 7.1