X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 91472D1B172
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 11 Jun 2004 05:25:55 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 82431-09
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 11 Jun 2004 08:25:54 +0000 (GMT)
Received: from rock.spider.ru (rock.spider.ru [62.183.34.226])
	by svr1.postgresql.org (Postfix) with ESMTP id CCB56D1B1BC
	for <pgsql-sql@postgresql.org>; Fri, 11 Jun 2004 05:25:50 -0300 (ADT)
Received: from rock (localhost [127.0.0.1])
	by rock (Postfix) with SMTP id 1DCBC9138B
	for <pgsql-sql@postgresql.org>; Fri, 11 Jun 2004 12:25:50 +0400 (MSD)
Received: from sad.localnet.ru (sad.localnet.ru [10.0.0.33])
	by rock.spider.ru (Postfix) with ESMTP id 80CEE91387
	for <pgsql-sql@postgresql.org>; Fri, 11 Jun 2004 12:25:49 +0400 (MSD)
Content-Type: text/plain;
  charset="us-ascii"
From: sad <sad@bankir.ru>
Organization: IT
To: pgsql-sql@postgresql.org
Subject: casting int to bit
Date: Fri, 11 Jun 2004 11:32:58 +0400
User-Agent: KMail/1.4.3
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200406111132.58908.sad@bankir.ru>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level: 
X-Archive-Number: 200406/97
X-Sequence-Number: 18042

PLEASE NOTE :

select 1::int8::bit(64);
0000000000000000000000000000000000000000000000000000000000000001

select 1::int4::bit(64);
0000000000000000000000000000000100000000000000000000000000000000

select 1::int2::bit(64);
ERROR:  Cannot cast type smallint to bit

the last is a great surprise for me !