| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Joachim Trinkwitz <jtr(at)uni-bonn(dot)de> |
| Cc: | <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: type casting bpchar |
| Date: | 2001-12-06 23:18:51 |
| Message-ID: | 20011206151755.A28880-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Larry Rosenman | 2001-12-06 23:36:28 | Trigger for logging stuff... |
| Previous Message | Larry Rosenman | 2001-12-06 23:02:46 | Trigger for logging stuff... |