Subject Re: [firebird-support] Question re: inserting data w/ Select and Concat
Author Magnus Titho
ioblefias wrote:
> 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?
Yes, this normally works, but you insert into the same table you do the
select from.
I guess this will lead to something like 'title-2-2-2-2-2-2-2-2-2-2' ...
until the field length is exceeded.

> isaac =)