Domain bit cast

From: Martin Sládek <forum(at)msw(dot)cz>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Domain bit cast
Date: 2004-11-05 10:00:05
Message-ID: 418B4F25.3090502@msw.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Cast int to domaim based on bit(n) works quite strange.

CREATE DOMAIN kat bit(40) NOT NULL;
SELECT 7::bit(40), 7::kat;

--on Win (7.5devel) and Linux (8.0.0b4)
bit | kat
0000000000000000000000000000000000000111 |
1000000000000000000000000000000000000000

--on Linux (7.4.6)
bit | kat
0000000000000000000000000000011100000000 |
0000000000000000000000000000011100000000

On 7.5 and 8.0 it seems that ::kat is ::bit::bit(40)

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Estevan Rech 2004-11-05 10:54:01 Installation error
Previous Message Tom Lane 2004-11-05 03:03:06 Re: could not find /usr/local/timezone