From: dennis <dennis@teltel.com>
Subject: Re: Help : insert a bytea data into new table
Date: Tue, 09 Mar 2010 15:45:42 +0800
Organization: Hub.Org Networking Services
Lines: 55
Message-ID: <hn4ub5$n7f$1@news.hub.org>
References: <hn49e1$2eob$1@news.hub.org>
	<20100309034626.GA12083@osiris.mauzo.dyndns.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
User-Agent: Thunderbird 2.0.0.23 (X11/20090817)
In-Reply-To: <20100309034626.GA12083@osiris.mauzo.dyndns.org>
To: pgsql-sql@postgresql.org

here is example

table name is "mail":
column    |   type
-------------------------
sender    |char
subject   |char
content   |bytea


I want copy some record into new table 'mail_new'.

sql:
create table mail_new as select * from mail sender='dennis'

result has an error:
operator does not exist: text || bytea


But if my sql statement has no column "content"
the sql works.
sql:
create table mail_new as select sender,subject from mail sender='dennis'


Ben Morrow 提到:
> Quoth dennis <dennis@teltel.com>:
>>     I need to copy some data to new table.
>> But I encounter some error message.
>> the table structure
>> Table A:
>>   c1  char
>>   c2  bytea
>>
>> Table B:
>>   c1  char
>>   c2  bytea
>>
>>
>> My sql command:
>> insert into B as select * from a where c1=xxx
> 
> 'AS' isn't valid there. What is xxx? Is it a field you haven't shown us,
> or is it a quoted string?
> 
>> error:
>> operator does not exist: text || bytea
> 
> That command (with 'xxx' quoted and the AS removed) doesn't give that
> error with those table definitions, so you will need to show us your
> actual query.
> 
> Ben
> 
>