pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedtype casting bpchar
2+ messages / 2 participants
[nested] [flat]
* type casting bpchar
@ 2001-12-06 18:33 Joachim Trinkwitz <jtr@uni-bonn.de>
0 siblings, 1 reply; 2+ messages in thread
From: Joachim Trinkwitz @ 2001-12-06 18:33 UTC (permalink / raw)
To: 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 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.
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/
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: type casting bpchar
@ 2001-12-06 23:18 Stephan Szabo <sszabo@megazone23.bigpanda.com>
parent: Joachim Trinkwitz <jtr@uni-bonn.de>
0 siblings, 0 replies; 2+ messages in thread
From: Stephan Szabo @ 2001-12-06 23:18 UTC (permalink / raw)
To: Joachim Trinkwitz <jtr@uni-bonn.de>; +Cc: 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.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2001-12-06 23:18 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-12-06 18:33 type casting bpchar Joachim Trinkwitz <jtr@uni-bonn.de>
2001-12-06 23:18 ` Stephan Szabo <sszabo@megazone23.bigpanda.com>
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