Representating a family tree

From: Guy Naor <guy(at)goldminesw(dot)co(dot)il>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Representating a family tree
Date: 2004-08-29 18:12:12
Message-ID: QU1LSVlXTyNGWzBAXVdWLTE1NDQ3ODYzMTI@cs-rnt-gnaor
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Are there any built in or known structures I can use in Postgres to represent a family tree?

The usual tree representations in SQL are for regular hierarchy of data, but on a family each node had usually 2 parents and a few child nodes. What will be the best way to represent something like this in an efficient manner?

Guy.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Oliver Elphick 2004-08-29 18:34:59 Re: Primary key inheritance problem
Previous Message Matthew M Davis 2004-08-29 17:07:39 Re: Primary key inheritance problem