Re: [GENERAL] CREATE TABLE with a column of type {table name}

2003-08-01 Thread Tom Lane
elein <[EMAIL PROTECTED]> writes: > IMNSHO a type is a type is a type. An instance of anytype > can go in a column. However, having worked in some of > the code to make this recursive definition work correctly > I understand your "No! Never!" response. I don't agree, > with it, but I understand

Re: [GENERAL] CREATE TABLE with a column of type {table name}

2003-07-31 Thread Stephan Szabo
On Thu, 31 Jul 2003, Ang Chin Han wrote: > In Postgresql 7.3, a datatype can be int, text, etc, and also > pseudo-types like RECORD, any, etc. > > These pseudo types are mainly used in CREATE FUNCTIONs, but what if it's > used in a CREATE TABLE, esp. when the name of another table is used as a >

[GENERAL] CREATE TABLE with a column of type {table name}

2003-07-31 Thread Ang Chin Han
In Postgresql 7.3, a datatype can be int, text, etc, and also pseudo-types like RECORD, any, etc. These pseudo types are mainly used in CREATE FUNCTIONs, but what if it's used in a CREATE TABLE, esp. when the name of another table is used as a datatype? e.g. -- Just for illustration: CREATE T