[plug] heirachal data in relational databases

James Devenish devenish at guild.uwa.edu.au
Mon Aug 9 10:54:57 WST 2004


In message <4116E560.8060404 at postnewspapers.com.au>
on Mon, Aug 09, 2004 at 10:45:52AM +0800, Craig Ringer wrote:
> I recall some discussion, quite some time ago, about how to store 
> heirachal trees of data in an SQL database. I think the general solution 
> was established then (a self-referential table)

I think that an article showing both an adjacency technique and a
preorder technique was cited. Hopefully that article is also still
online. Not sure how it compares to your citation, as I have not read
it.

> http://www.onlamp.com/pub/a/onlamp/2004/08/05/hierarchical_sql.html







More information about the plug mailing list