Re: [SQL] Help : insert a bytea data into new table

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:

Re: [SQL] Help : insert a bytea data into new table

Hi Ben here is my function , it's for fix missing chunk problem. It has same problem ,please take look thank for you help -table-- db=# \d usersessiontable; Table public.usersessiontable Column | Type | Modifiers

Re: [SQL] Help : insert a bytea data into new table

Postgres : 8.1.4 Dennis Ben Morrow wrote: Quoth dennisden...@teltel.com: Dear Ben thanks for you anwser. I try to add function quote_literal on my sql statement . but it raise other error message (quote_literal not support bytea format): function quote_literal(bytea) does

Re: [SQL] Help : insert a bytea data into new table

Dear Ben thanks for you anwser. I try to add function quote_literal on my sql statement . but it raise other error message (quote_literal not support bytea format): function quote_literal(bytea) does not exist Ben Morrow 提到: Quoth dennis den...@teltel.com: Hi Ben here is my

Re: [SQL] Help : insert a bytea data into new table

Quoth dennis den...@teltel.com: Dear Ben thanks for you anwser. I try to add function quote_literal on my sql statement . but it raise other error message (quote_literal not support bytea format): function quote_literal(bytea) does not exist Which Postgres version are you

Re: [SQL] Help : insert a bytea data into new table

[quoting fixed] Quoth dennis dennis.ma...@gmail.com: Ben Morrow wrote: Quoth dennisden...@teltel.com: Dear Ben thanks for you anwser. I try to add function quote_literal on my sql statement . but it raise other error message (quote_literal not support bytea format):

Re: [SQL] Help : insert a bytea data into new table

Quoth dennis den...@teltel.com: Hi Ben here is my function , it's for fix missing chunk problem. It has same problem ,please take look thank for you help -table-- db=# \d usersessiontable; Table public.usersessiontable Column |

Re: [SQL] Help : insert a bytea data into new table

Quoth dennis den...@teltel.com: here is example table name is mail: column| type - sender|char subject |char I presume you mean 'varchar'? content |bytea I want copy some record into new table 'mail_new'. sql: create table mail_new as

Re: [SQL] Help : insert a bytea data into new table

Quoth dennis den...@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