On Thu, Feb 12, 2009 at 5:03 AM, Sim Zacks <sim@xxxxxxxxxxxxxx> wrote: > -----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. I'm scheming to get that fixed. The main reason is that while the insert workaround works, there is no similar workaround for 'update'. merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general