type cast about int to bit

From: zoulx1982 <zoulx1982(at)163(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: type cast about int to bit
Date: 2012-02-06 06:11:12
Message-ID: 18656bf8.13415.13551499b55.Coremail.zoulx1982@163.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

hi,
there is a problem about type cast that i don't understand, follow is my test.

postgres=# select 10::bit(3);
bit
-----
010
(1 row)
postgres=# select 10::bit varying(3);
ERROR: cannot cast type integer to bit varying
LINE 1: select 10::bit varying(3);
^
postgres=#

my question is why int can cast to bit , i want to know the reason.
thank you for your timing.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Achilleas Mantzios 2012-02-06 08:42:43 Re: array dimensions, pg_catalog.pg_attribute and the \d command
Previous Message Viktor Bojović 2012-02-05 13:56:31 Re: Is there a way to remove every character but numbers?