row constructors - Mailing list pgsql-general

From Sim Zacks
Subject row constructors
Date
Msg-id gn0rta$2647$1@news.hub.org
Whole thread Raw
Responses Re: row constructors  (Sim Zacks <sim@compulab.co.il>)
List pgsql-general
-----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 this functionality.

Thank you
Sim
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkmT8ukACgkQjDX6szCBa+oI/wCghmqMF+FyNl1xz3E6xQSIr4ll
r04An05goEOsaTh+Ni5CEC9zjFRAqPCd
=uXgD
-----END PGP SIGNATURE-----

pgsql-general by date:

Previous
From: Abdul Rahman
Date:
Subject: Re: Multiple postgres.exe On Processes
Next
From: Sam Mason
Date:
Subject: Re: Making a result of transaction visible to everyone, saving the ability for a rollback