Re: get date in binary number format

Alvaro Herrera <alvherre@atentus.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