On Thu, Feb 12, 2009 at 11:38 AM, Rory Campbell-Lange
wrote:
> On 12/02/09, Merlin Moncure (mmonc...@gmail.com) wrote:
>> On Thu, Feb 12, 2009 at 5:03 AM, Sim Zacks wrote:
>> > Never mind. I found an old post.
>> > I just needed to do:
>> > insert into a1 select (f2).* from a2;
>> >
>> > I didn't
On 12/02/09, Merlin Moncure (mmonc...@gmail.com) wrote:
> On Thu, Feb 12, 2009 at 5:03 AM, Sim Zacks wrote:
> > 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
> > c
On Thu, Feb 12, 2009 at 5:03 AM, Sim Zacks 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 t
-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 wrot
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
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 th
