bitfromint4() in v7.2.3 to bit() in v8.1? - Mailing list pgsql-bugs

From Björn Þór Jónsson
Subject bitfromint4() in v7.2.3 to bit() in v8.1?
Date
Msg-id 9e3f7cd20904201901s34a64071lc333539f60829145@mail.gmail.com
Whole thread Raw
Responses Re: bitfromint4() in v7.2.3 to bit() in v8.1?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Hi,

In version 7.2.3 this works fine:

select substring(bitfromint4(cast (-2^31 + 22 as int4)), 1, 32);

and now I'm porting the legacy code, that this line is part of, to version 8.1 but am having no luck updating it - have tried something like:

select substring(bit(cast (-2^31 + 22 as int4)), 1, 32);
and
select substring("bit"(cast (-2^31 + 22 as int4)), 1, 32);
and
select substring(1::"bit"(cast (-2^31 + 22 as int4)), 1, 32);

with no luck.


How can this be solved?


/Björn

pgsql-bugs by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: Scripting issue
Next
From: Paolo Saul
Date:
Subject: Segfaults When Inserting into a Geom Index