pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Joachim Trinkwitz <jtr@uni-bonn.de>
To: pgsql-sql@postgresql.org
Subject: type casting bpchar
Date: 06 Dec 2001 19:33:14 +0100
Message-ID: <871yi8xkph.fsf@waffel.germanistik.uni-bonn.de> (raw)

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/



view thread (2+ messages)  latest in thread

Message-ID: <871yi8xkph.fsf@waffel.germanistik.uni-bonn.de>
Permalink:  ../871yi8xkph.fsf@waffel.germanistik.uni-bonn.de/
Also on:    postgresql.org/message-id/871yi8xkph.fsf@waffel.germanistik.uni-bonn.de

 · 

reply

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: jtr@uni-bonn.de
  Subject: Re: type casting bpchar
  In-Reply-To: <871yi8xkph.fsf@waffel.germanistik.uni-bonn.de>

* 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