Ron Peterson <ron(dot)peterson(at)yellowbank(dot)com> 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