Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group