Ron Peterson <ron.peterson@xxxxxxxxxxxxxx> writes: > How should I create a composite type value out of columns a and b in > table tt that I can insert into table atable? Hm, it works for me with an explicit cast: INSERT INTO atable SELECT ROW(a, b)::atype FROM tt; Perhaps we should allow this in an automatic or even implicit cast context. regards, tom lane
