Alvaro Herrera <alvherre(at)atentus(dot)com> writes:
> Is there a way to cast these bitstrings into varchars or something? I
> can't find any.
regression=# select ("bit"((date_part('doy', now()))::integer))::text;
ERROR: Cannot cast type bit to text
Evidently not :-(.
Now that we have the ability to create casts that aren't applied
implicitly, it should be safe to create a lot more casts than we have
now, for example the bool<->int conversions that people keep asking for.
We ran out of time to attack that in 7.3, but I hope we will do more
in 7.4.
regards, tom lane