[GENERAL] Reference Type in PostgreSQL

[Elena]

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 can I define it in PostgreSQL? I haven't found it in the manuals.

Thank you for help.

--
Elena



--
Elena