X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D378AD1B56E for ; Sun, 25 Jul 2004 21:46:31 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 80840-06 for ; Mon, 26 Jul 2004 00:46:31 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id E7055D1B540 for ; Sun, 25 Jul 2004 21:46:27 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i6Q0kRqb052714 for ; Mon, 26 Jul 2004 00:46:27 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i6Q0MZHZ050207 for pgsql-hackers@postgresql.org; Mon, 26 Jul 2004 00:22:35 GMT From: Gaetano Mendola X-Newsgroups: comp.databases.postgresql.hackers Subject: Re: 7.5 release notes Date: Mon, 26 Jul 2004 02:22:21 +0200 Organization: PYRENET Midi-pyrenees Provider Lines: 47 Message-ID: <41044EBD.7030608@bigfoot.com> References: <1090752623.3057.284.camel@localhost.localdomain> <200407252355.i6PNtoc13198@candle.pha.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@pyrenet.fr To: Bruce Momjian User-Agent: Mozilla Thunderbird 0.7.1 (Windows/20040626) X-Accept-Language: en-us, en In-Reply-To: <200407252355.i6PNtoc13198@candle.pha.pa.us> X-Enigmail-Version: 0.84.2.0 X-Enigmail-Supports: pgp-inline, pgp-mime To: pgsql-hackers@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/1220 X-Sequence-Number: 56781 In the release not I can read: #Allow arbitrary row expressions (Tom) This allows columns to contain arbitrary composite types like rows from other tables. [SNIPPED] Wasn't this alread true on 7.4 ? See: kalman=# select version(); version --------------------------------------------------------------------------------------------------------- PostgreSQL 7.4.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.2 20030222 (Red Hat Linux 3.2.2-5) (1 row) kalman=# create table test ( a varchar, b varchar, c varchar ); CREATE TABLE kalman=# create table test1 ( d integer, e test ); CREATE TABLE kalman=# select * from test1; d | e ---+--- (0 rows) kalman=# select e from test1; e --- (0 rows) kalman=# select (e).a from test1; a --- (0 rows) Regards Gaetano Mendola