Re: function bit(integer)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Samer Abukhait <abukhait(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: function bit(integer)
Date: 2005-05-15 21:33:49
Message-ID: 763.1116192829@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Samer Abukhait <abukhait(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message tony 2005-05-16 07:48:08 date problem
Previous Message Samer Abukhait 2005-05-15 20:23:26 Re: function bit(integer)