Hi, I am having problems manipulating bit strings.

CREATE TABLE lookup(
fname TEXT PRIMARY KEY,
digest BIT VARYING
);

I am trying to construct another bit string based on the length of the 
first:

SELECT b'1'::bit( bit_length( digest ) ) FROM lookup;

This doesn't work as i had hoped, where am I going wrong?

Thanks!

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html

Reply via email to