Scott Ribe <scott_ribe(at)killerbytes(dot)com> 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 table individually?
Can't you do something like
INSERT INTO B SELECT *, some-more-values FROM A WHERE ...
regards, tom lane