Re: Threaded Records in SQL: Advice Needed

> Hi Everyone,
>  
> I'm planning to implement a project using a php/postgres 6.5.3 combination.
>
> Part of what I need to do is develop a model in SQL to keep track of
> "threaded records."  What I mean by this, is that I need to keep track of
> parent-child relationships in exactly the same way that a
> threaded-discussion group does.


Hi Bryan

check out the PDF files at

http://ourworld.compuserve.com/homepages/Graeme_Birchall/HTM_COOK.HTM

The "SQL Cookbook" that this guy writes is oriented towards IBM's DB2
database, however, he does talk about a number of different ways of handling
parent-child relationships in an SQL table; his versions are able to be
nested as well.

Actually, this guy seems to know his stuff when it comes to SQL, so it is
probably worth having a look at anyways...thus I have also posted this
response to the list.

Cordially

Patrick Giagnocavo
a222@redrose.net