Re: Reference Type in PostgreSQL

On 3/19/07, Elena <elena(dot)planas(at)gmail(dot)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