Re: Reference Type in PostgreSQL

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