Home > mailing lists

Re: Table Design for Hierarchical Data - Mailing list pgsql-sql

From	silly sad
Subject	Re: Table Design for Hierarchical Data
Date	April 7, 2010 05:41:26
Msg-id	4BBC1AF6.1000200@bankir.ru Whole thread Raw
In response to	Table Design for Hierarchical Data (Lee Hachadoorian <lee.hachadoorian@gmail.com>)
List	pgsql-sql

single table.
nested tree + ordinal parent reference.

nests are calculated in a trigger on insert.

From: Steve Crawford
Date: 07 April 2010, 00:54:28
Subject: Re: Table Design for Hierarchical Data

From: silly sad
Date: 07 April 2010, 05:43:52
Subject: Re: Table Design for Hierarchical Data