Re: row constructors - Mailing list pgsql-general

From Merlin Moncure
Subject Re: row constructors
Date
Msg-id b42b73150902120815g52e8e91bocdd2010a85c54913@mail.gmail.com
Whole thread Raw
In response to Re: row constructors  (Sim Zacks <sim@compulab.co.il>)
Responses Re: row constructors
List pgsql-general
On Thu, Feb 12, 2009 at 5:03 AM, Sim Zacks <sim@compulab.co.il> 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

pgsql-general by date:

Previous
From: Rory Campbell-Lange
Date:
Subject: Re: Update table with random values from another table
Next
From: Tom Lane
Date:
Subject: Re: covering indexes?