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