On 3/19/07, Elena <elena.planas@xxxxxxxxx> 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
