Reference Type in PostgreSQL

[Elena <elena.planas@xxxxxxxxx>]

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