Re: function bit(integer) - Mailing list pgsql-general

Samer Abukhait <abukhait@gmail.com> writes:
> select "bit"(1);
> ERROR:  function bit(integer) does not exist

Try
    select 1::bit(32);
or if you prefer
    select cast(1 as bit(32));

What you have above is essentially a direct invocation of the int-to-bit
cast function; which you can do if you like, but it's deprecated for
precisely the reason that we don't promise it'll remain stable.

            regards, tom lane