Обсуждение: bitfromint4() in v7.2.3 to bit() in v8.1?

Поиск

Список

Период

Сортировка

bitfromint4() in v7.2.3 to bit() in v8.1?

От

Björn Þór Jónsson

Дата:

21 апреля 2009 г., 04:17:36

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

Re: bitfromint4() in v7.2.3 to bit() in v8.1?

От

Tom Lane

Дата:

21 апреля 2009 г., 11:01:03

Björn Þór Jónsson <bangsi@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

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Обсуждение: bitfromint4() in v7.2.3 to bit() in v8.1?

bitfromint4() in v7.2.3 to bit() in v8.1?

Re: bitfromint4() in v7.2.3 to bit() in v8.1?