Re: ERROR: cannot cast type text to bit varying

Поиск
Список
Период
Сортировка
От Matt Miller
Тема Re: ERROR: cannot cast type text to bit varying
Дата
Msg-id 1118358041.3596.54.camel@dbamm01-linux
обсуждение исходный текст
Ответ на Re: ERROR: cannot cast type text to bit varying  (Alvaro Herrera <alvherre@surnet.cl>)
Список pgsql-general
> > I ended up writing a bunch of code to accomplish what I initially
> > thought would be just some casting and bitops on built-in types.

> I imagine you could have done something involving textout() and
> varbit_in(), like
>
> alvherre=# select varbit_in(textout(translate('YYNY', 'YN', '10')), 123::oid, 32);
>  varbit_in
> -----------
>  1101
> (1 fila)

Ah... This is more like it.  Thank you.

I'll explore this more tomorrow.  Are "varbit_in" and "textout"
documented?

В списке pgsql-general по дате отправления:

Предыдущее
От: elein@varlena.com (elein)
Дата:
Сообщение: Re: Version Control?
Следующее
От: "Otto Blomqvist"
Дата:
Сообщение: Setting all elements in an Bool[] array to the same value