Received: from waffel.germanistik.uni-bonn.de (waffel.germanistik.uni-bonn.de [131.220.90.150]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fB6IXFm78660 for ; Thu, 6 Dec 2001 13:33:16 -0500 (EST) (envelope-from jtr@uni-bonn.de) Received: by waffel.germanistik.uni-bonn.de (Postfix, from userid 1000) id 3058E131A12; Thu, 6 Dec 2001 19:33:14 +0100 (CET) To: pgsql-sql@postgresql.org Subject: type casting bpchar From: Joachim Trinkwitz Date: 06 Dec 2001 19:33:14 +0100 Message-ID: <871yi8xkph.fsf@waffel.germanistik.uni-bonn.de> Lines: 25 User-Agent: Gnus/5.0808 (Gnus v5.8.8) XEmacs/21.4 (Civil Service) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200112/79 X-Sequence-Number: 5902 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/