Re: Table Design for Hierarchical Data

From: silly sad <sad(at)bankir(dot)ru>
To: Lee Hachadoorian <lee(dot)hachadoorian(at)gmail(dot)com>
Cc: pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Table Design for Hierarchical Data
Date: 2010-04-07 05:41:10
Message-ID: 4BBC1AF6.1000200@bankir.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

single table.
nested tree + ordinal parent reference.

nests are calculated in a trigger on insert.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message silly sad 2010-04-07 05:43:37 Re: Table Design for Hierarchical Data
Previous Message Steve Crawford 2010-04-07 00:23:34 Re: Table Design for Hierarchical Data