Re: recursive relationship

From: Huber Heinz <Heinz.Huber_at_elbanet.co.at>
Date: 2000/01/12
Message-ID: <387C79AB.26AD5315@elbanet.co.at>#1/1

AFAIK, a recursive relationship means that an object of a certain type may be related to an object of the same type. Consider the type human, spouse is such a relationship (perhaps you have to add "current";-)

CREATE TABLE Human (

    ID            INTEGER,
    Name          CHAR (255),
    IDSpouse      INTEGER);

Hope I'm not wrong
Heinz

Fernando wrote:
>
> hi!
>
> I dont understand very well the concept of a recursive
> relationship. Could someone please explain and give me an example?
> O:-)
>
> A sample sql statement that creates a table with such a
> relationship would be appreciated too. O:-)
>
> TIA
>
> //-----------------------------------------------
> // Fernando Rodriguez Romero
> //
> // frr at mindless dot com
> //------------------------------------------------
Received on Wed Jan 12 2000 - 00:00:00 CST