row constructors

From: Sim Zacks <sim(at)compulab(dot)co(dot)il>
To: pgsql-general(at)postgresql(dot)org
Subject: row constructors
Date: 2009-02-12 09:59:05
Message-ID: gn0rta$2647$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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-----

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sim Zacks 2009-02-12 10:03:26 Re: row constructors
Previous Message Harald Armin Massa 2009-02-12 09:54:18 Re: Multiple postgres.exe On Processes