-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
-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
On Thu, Feb 12, 2009 at 5:03 AM, Sim Zacks s...@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
On 12/02/09, Merlin Moncure (mmonc...@gmail.com) wrote:
On Thu, Feb 12, 2009 at 5:03 AM, Sim Zacks s...@compulab.co.il 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
On Thu, Feb 12, 2009 at 11:38 AM, Rory Campbell-Lange
r...@campbell-lange.net wrote:
On 12/02/09, Merlin Moncure (mmonc...@gmail.com) wrote:
On Thu, Feb 12, 2009 at 5:03 AM, Sim Zacks s...@compulab.co.il wrote:
Never mind. I found an old post.
I just needed to do:
insert into a1 select