> Can't you do something like
>
> INSERT INTO B SELECT *, some-more-values FROM A WHERE ...
Yes, that works. I didn't think of trying that because I also need to check
for existence of A and change some values in it if it exists, so I select it
into a record type, and
insert into B docrec.*,
Scott Ribe <[EMAIL PROTECTED]> writes:
> 1) Is there any way to change a row of table A into one of the inherited
> types, other than deleting and inserting?
Nope.
> 2) If I must delete & insert, is there any shortcut to somehow say rec2.A =
> rec1 rather than referencing the columns of the base
