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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
