Re: row constructors

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Sim Zacks <sim(at)compulab(dot)co(dot)il>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: row constructors
Date: 2009-02-12 16:15:34
Message-ID: b42b73150902120815g52e8e91bocdd2010a85c54913@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Feb 12, 2009 at 5:03 AM, Sim Zacks <sim(at)compulab(dot)co(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rory Campbell-Lange 2009-02-12 16:15:54 Re: Update table with random values from another table
Previous Message Tom Lane 2009-02-12 16:13:42 Re: Update table with random values from another table