=?ISO-8859-1?B?Qmr2cm4g3vNyIErzbnNzb24=?= <ban...@bthj.is> writes:
> 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:
Use a cast, eg
regression=# select cast (-2^31 + 22 as int4)::bit(32);
bit
----------------------------------
10000000000000000000000000010110
(1 row)
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
