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)
Список
Дерево обсуждения
ERROR: cannot cast type text to bit varying Matt Miller <mattm@epx.com>
Re: ERROR: cannot cast type text to bit varying Matt Miller <mattm@epx.com>
Re: ERROR: cannot cast type text to bit varying Matt Miller <mattm@epx.com>
Re: ERROR: cannot cast type text to bit varying Alvaro Herrera <alvherre@surnet.cl>
Re: ERROR: cannot cast type text to bit varying Matt Miller <mattm@epx.com>
> > 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 по дате отправления
От: Otto Blomqvist
Дата: