type casting bpchar

Поиск
Список
Период
Сортировка
От Joachim Trinkwitz
Тема type casting bpchar
Дата
Msg-id 871yi8xkph.fsf@waffel.germanistik.uni-bonn.de
обсуждение исходный текст
Ответы Re: type casting bpchar
Список pgsql-sql
Dear all,

I want to alter a table by creating a similar temporary table with my
modifications and inserting the values of the old table, but I get the
error message:

ERROR:  Attribute 'tag' is of type '_bpchar' but expression is of type 'bpchar'       You will need to rewrite or cast
theexpression
 

Question is how do I do this, because when I write the offending value
as tag::_bpchar, I get:

ERROR:  Cannot cast type 'bpchar' to '_bpchar'

This seems to be a dilemma which I don't know how to solve. I hope
someone can help me.

Greetings,
joachim

--          Dr. Joachim Trinkwitz              email: jtr@uni-bonn.de        Germanistisches Seminar             phone:
0228-737565
Rheinische Friedrich-Wilhelms-Universitaet   fax:   0228-737479     Am Hof 1d, 53113 Bonn, Germany         web:
http://www.germanistik.uni-bonn.de/jtr/


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

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: how to chane the type
Следующее
От: Oleg Lebedev
Дата:
Сообщение: view rules