On 3/19/07, Elena <[EMAIL PROTECTED]> wrote:
Hello all, I'm new in PostgreSQL...I would want to know like PostgreSQL manages the type reference that defines the standard SQL:1999. I want to define the type of attribute like a reference at other type. For example, in Oracle8i the definition is: -- Type Department CREATE OR REPLACE TYPE Department_type AS OBJECT ( code NUMBER(5), name VARCHAR(40) ); -- Type Employee CREATE OR REPLACE TYPE Employee_type AS OBJECT ( code NUMBER(5), name VARCHAR2(40), department REF Department_type -- Reference to Department object type );
how is this different from simply nesting the types? merlin ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
