Re: 7.3b2 ?bug? bitfromint4 is not working - Mailing list pgsql-hackers

From Tom Lane
Subject Re: 7.3b2 ?bug? bitfromint4 is not working
Date
Msg-id 13866.1034453103@sss.pgh.pa.us
Whole thread Raw
In response to 7.3b2 ?bug? bitfromint4 is not working  (Neophytos Demetriou <k2pts@cytanet.com.cy>)
Responses Re: 7.3b2 ?bug? bitfromint4 is not working  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Neophytos Demetriou <k2pts@cytanet.com.cy> writes:
> I must be missing something obvious here but it seems that bitfromint4 
> is not working under 7.3b2. I can still see bitfromint4 in the source 
> code, utils/adt/varbit.c, but it is no longer working. Any ideas why?

It's still there:

regression=# select "bit"(42);              bit
----------------------------------00000000000000000000000000101010
(1 row)

However, it's not listed in pg_cast :-(

regression=# select cast(42 as bit);
ERROR:  Cannot cast type integer to bit

Looking at the CVS logs, this seems to be caused by overlapping changes.
On 4-Aug Thomas renamed bittoint4 and bitfromint4 to match the more
usual naming conventions for cast functions, viz int4(bit) and
bit(int4), and he also added int8(bit) and bit(int8).  This was after
Peter had trolled the catalogs for cast functions and created the
initial contents of pg_cast.h (on 18-Jul).

Upshot: we have here four functions that ought to be in pg_cast and are
not.

Is it worth an initdb for 7.3b3 to fix this?  I think we were already
considering forcing one for the command-tag issues, otherwise I'd
probably vote "no".  Comments?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Steven Singer
Date:
Subject: Triggers and Schema's.
Next
From: Tom Lane
Date:
Subject: Re: Triggers and Schema's.