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 table individually?
Can't you do something like
INSERT INTO B SELECT *, some-more-values FROM A WHERE ...
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
