-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Never mind. I found an old post.
I just needed to do:
insert into a1 select (f2).* from a2;
I didn't find it the first time I searched because I was looking for row
constructors, and the post I found used the term composite value.
Sim
Sim Zacks wrote:
> Is there any way to insert a row constructor into the table of the same
> type?
>
> For example:
> create table a1(id int, f1 text);
> create table a2(id int, f2 a1);
>
> insert into a1 select f2 from a2;
>
> This doesn't work, I am looking for a way to accomplish this functionality.
>
> Thank you
> Sim
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iEYEARECAAYFAkmT8+4ACgkQjDX6szCBa+oqLgCgw2AZjkhiaWGNYpvICTHPkEii
rIsAoO3fYRxh5+Ohws2+IZG2RzO8Q9B6
=Gt11
-----END PGP SIGNATURE-----