Re: type casting bpchar

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: type casting bpchar
Дата
Msg-id 20011206151755.A28880-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на type casting bpchar  (Joachim Trinkwitz <jtr@uni-bonn.de>)
Список pgsql-sql
On 6 Dec 2001, Joachim Trinkwitz wrote:

> 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 the expression
>
> 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.

Can you send the create statements for the two tables?  It looks like
one of the two has an array of chars, but I'm not sure.



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

Предыдущее
От: Keith Gray
Дата:
Сообщение: Re: Inline IF condition
Следующее
От: Larry Rosenman
Дата:
Сообщение: Trigger for logging stuff...