Re: type casting bpchar - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: type casting bpchar
Date
Msg-id 20011206151755.A28880-100000@megazone23.bigpanda.com
Whole thread Raw
In response to type casting bpchar  (Joachim Trinkwitz <jtr@uni-bonn.de>)
List 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 by date:

Previous
From: Keith Gray
Date:
Subject: Re: Inline IF condition
Next
From: Larry Rosenman
Date:
Subject: Trigger for logging stuff...