Re: [GENERAL] function bit(integer)

2005-05-15 Thread Tom Lane
Samer Abukhait <[EMAIL PROTECTED]> 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

Re: [GENERAL] function bit(integer)

2005-05-15 Thread Samer Abukhait
I have some code that uses this "type name" and the 8.0.3 is not recognizing it -- Executing query: select "bit"(1); ERROR: function bit(integer) does not exist HINT: No function matches the given name and argument types. You may need to add explicit type casts. ---(end

Re: [GENERAL] function bit(integer)

2005-05-15 Thread Tom Lane
Michael Fuhr <[EMAIL PROTECTED]> writes: > On Sun, May 15, 2005 at 01:30:05PM +0200, Samer Abukhait wrote: >> whats the story of the function bit? > I don't see the bit() function in the 8.0.3 documentation, so you > might want to stick with documented functionality. bit(n) is a type name, not a

Re: [GENERAL] function bit(integer)

2005-05-15 Thread Michael Fuhr
On Sun, May 15, 2005 at 01:30:05PM +0200, Samer Abukhait wrote: > > whats the story of the function bit? > was it out there some previous versions and got removed lately?? > > My 8.0.2 PG hasn't this function, if i found this function any where > in previous code, shall i replace it with INT::bit(