What about these?

test=# select B'1' << 4;
  ?column?
----------
  0
(1 row)

test=# select B'1'::bit varying << 4;
  ?column?
----------
  0
(1 row)

test=# select '1'::bit varying << 4;
  ?column?
----------
  0
(1 row)



Mon, 14 Jun 2004 11:10:15 +0800
Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Other bit oddities