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)
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
