Re: Bug and/or feature? Complex data types in tables...

"Chris Travers" <chris(at)travelamericas(dot)com> writes:
> Try the following example:

> CREATE TABLE test1 (
> test_id SERIAL,
> test_text TEXT
> );

> CREATE TABLE test2 (
> other_test test1,
> test_text text
> );

This should in fact be disallowed, I think. Back in the pre-SQL days of
Berkeley Postgres, there actually was a feature that involved declaring
table columns this way, but it did NOT work the way you think ;-), and
in any case it has been broken for many years.

I'm not sure why we've never taken the step of preventing complex types
from being declared as fields of other types. I suppose there's some
thought that we'll eventually support it, but I don't believe that that
day is real close.

regards, tom lane