Re: [HACKERS] about type cast

2012-02-06 Thread Tom Lane
Robert Haas writes: > 2012/2/6 zoulx1982 : >> my question is why int can cast to bit , but bot for bit varying? > Off the top of my head, I'm guessing that it's just a case of nobody > having implemented it. I have some vague recollection that we didn't want to be squishy about the length of the

Re: [HACKERS] about type cast

2012-02-06 Thread Robert Haas
2012/2/6 zoulx1982 : > 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(

[HACKERS] about type cast

2012-02-06 Thread zoulx1982
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 ques