Subject Question re: inserting data w/ Select and Concat
Author ioblefias

i am new to firebird, and as i have been trying to insert data on my
newly created table, i tried this sql:

insert into titles(title, film_type)
select title||'-2', film_type
from titles;

but it does not work, and this error message is displayed: 'error:
arithmetic expression, numeric overflow or string truncation'.

is there any way to use the select statement with concatenation in
order to insert data?

thanks in advance,

isaac =)