Binary data in bit(n) has no text equivalent, and so cannot be "cast" as text. It has an "external representation", e.g. B'10010101', but this is not the same as a cast. In some cases, where there bit(n) has (n mod 8) = 0 and the bitstring happens to be valid ascii in the text range, one could say there is a text equivalent, but in general not.
I think you're looking for some kind of printf-type %b function? Maybe someone has written one, or maybe you'll have to do so. If you do, how about a hex representation of bit(n) - I could use that ;) TJ O'Donnell http://www.gnova.com/ ----- But this is the big problem for me... Is there a way to cast bit(n) to text or varchar? thanks in advance. Sergey Karin ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
