Outputting PostgreSQL's bit type in SQuirreL results in "<Error>"

Question

When I try to output something as a bitstring (PostgreSQL documentation) in SQuirreL...

SELECT ('1234'::bigint)::bit(16);

I get the following result:

    bit
-------
<Error>

Can this be avoided?

Answer 1

It seems the type is not supported by SQuirreL, but adding another cast to varchar works:

SELECT ('1234'::bigint)::bit(16)::varchar;

Output:

varchar         
----------------
0000010011010010