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 released version.
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