Thread: Bug #858: bitfromint4 not present in 7.3.1

Andrew Goldsmith (andrew.goldsmith@telstra.com) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
bitfromint4 not present in 7.3.1

Long Description
I have installed a copy of PostgreSQL 7.3.1 from src on my Debian/Linux system.  The bitfromint4 function is no longer
recognised,e.g. when trying to call from psql command line: 
test=# select bitfromint4(4);
ERROR:  Function bitfromint4(integer) does not exist
        Unable to identify a function that satisfies the given argument types
        You may need to add explicit typecasts

Based on passed bug reports this was a known problem with 7.3b2
[http://archives.postgresql.org/pgsql-hackers/2002-10/msg00595.php]and doesn't seem to have been resolved for the
releasedversion. 

Sample Code


No file was uploaded with this report

pgsql-bugs@postgresql.org writes:
> bitfromint4 not present in 7.3.1

This is not a bug, but an intentional change.  It's called "bit" now,
as it should have been all along --- the original author was apparently
unaware of the naming conventions Postgres has for type-coercion
functions.

            regards, tom lane