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?
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