Received: from smtp1.supernet.com (IDENT:qmailr@smtp1.desupernet.net
	[204.249.184.44]) by hub.org (8.9.3/8.9.3) with SMTP id OAA62888
	for <pgsql-sql@postgresql.org>; Mon, 10 Apr 2000 14:29:50 -0400 (EDT)
	(envelope-from a222@redrose.net)
Message-Id: <200004101829.OAA62888@hub.org>
Received: (qmail 26002 invoked from network); 10 Apr 2000 18:29:42 -0000
Received: from isdnded.wentworthpublishing.com (HELO ?192.168.100.141?)
	(204.249.185.60)
	by smtp1.supernet.com with SMTP; 10 Apr 2000 18:29:42 -0000
X-Mailer: Microsoft Outlook Express Macintosh Edition - 4.5 (0410)
Date: Mon, 10 Apr 2000 14:25:39 -0400
Subject: Re: Threaded Records in SQL: Advice Needed
From: "Patrick Giagnocavo" <a222@redrose.net>
To: pgsql-sql@postgresql.org
Mime-version: 1.0
X-Priority: 3
Content-type: text/plain; charset="US-ASCII"
Content-transfer-encoding: 7bit
X-Archive-Number: 200004/93

> 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