Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

Next:From: Oliver ElphickDate: 2004-08-29 18:34:59
Subject: Re: Primary key inheritance problem
Previous:From: Matthew M DavisDate: 2004-08-29 17:07:39
Subject: Re: Primary key inheritance problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group