Representating a family tree - Mailing list pgsql-general

From Guy Naor
Subject Representating a family tree
Date
Msg-id QU1LSVlXTyNGWzBAXVdWLTE1NDQ3ODYzMTI@cs-rnt-gnaor
Whole thread Raw
Responses Re: Representating a family tree
List 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
parentsand a few child nodes. What will be the best way to represent something like this in an efficient manner? 

Guy.

pgsql-general by date:

Previous
From: "Frank Millman"
Date:
Subject: Problem with select and null
Next
From: "Richard Watson"
Date:
Subject: Re: monitor+keyboard+mouse together