Re: (7.1) BIT datatype

"Christopher Kings-Lynne" wrote: >I have been using the BIT and VARBIT types in Postgres 7.0.3 (undocumented I
>believe),and I note that the _input_ format is as follows: > >update blah set flags='b101001';  -- Binary
 

That is still accepted.
 >update blah set flags='xff45';  -- Hex 
That is not.
 >But the _output_ format (for varbit) is always: > >B'1010110'


bray=# select * from junk; id  | flag1 |  flags   | flags2 
------+-------+----------+--------AAAA | 1     | 11000101 | BBBB | 0     | 00111010 | cccc | 0     | 01101100 |
11001dddd| 0     | 01100000 | 
 
 >Has any of this changed in 7.1?

-- 
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47  6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
========================================   "And there were in the same country shepherds abiding      in the field,
keepingwatch over their flock by night.     And, lo, the angel of the Lord came upon them, and the     glory of the
Lordshone around them; and they were      sore afraid. And the angel said unto them, " Fear not;     for behold I bring
yougood tidings of great joy which     shall be to all people. For unto you is born this day      in the city of David
aSaviour, which is Christ the      Lord."        Luke 2:8-11