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 =)
>

--
Magnus