From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: Joachim Trinkwitz <jtr@uni-bonn.de>
Cc: pgsql-sql@postgresql.org
Subject: Re: type casting bpchar
Date: Thu, 6 Dec 2001 15:18:51 -0800 (PST)
Message-ID: <20011206151755.A28880-100000@megazone23.bigpanda.com> (raw)
In-Reply-To: <871yi8xkph.fsf@waffel.germanistik.uni-bonn.de>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sszabo@megazone23.bigpanda.com, jtr@uni-bonn.de
Subject: Re: type casting bpchar
In-Reply-To: <20011206151755.A28880-100000@megazone23.bigpanda.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox