domain on bit(N) type produces strange results

From: Kris Jurka <books(at)ejurka(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: domain on bit(N) type produces strange results
Date: 2004-11-06 05:34:39
Message-ID: Pine.BSO.4.56.0411060026120.10337@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


Creating a domain on bit(N) doesn't seem to work as expected when casting
to the domain type.

CREATE DOMAIN bit4 AS bit(4);

SELECT 7::bit(4), 7::bit4;
bit | bit4
------+------
0111 | 1000
(1 row)

Reported in #postgresql by msw_alt.

Kris Jurka

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David Dick 2004-11-06 05:44:52 Re: BUG #1306: locale related issue.
Previous Message Tom Lane 2004-11-06 05:27:14 Re: BUG #1306: locale related issue.