--- In ib-support@yahoogroups.com, Joe Martinez <joe@j...> wrote:

> Let's say I have two tables: Table1 and Table2, with the exact same

structure.

>
> I can do:
>
> insert into table 1 select * from table2 where ...
>
> What happens if the tables have a computed field? Will this bomb

out

> because you can't set the values of computed columns? Or, is FB

smart

> enough to skip the computed columns?

Joe, I don't like computed columns, so can't answer. But I surely
know - to make two test tables, insert one record into one of them and
try insert from select requires no more than 10 minutes. Please make
it and tell us result ;))

Best regards, Alexander.