From: Patrick Giagnocavo <a222@redrose.net>
To: pgsql-sql@postgresql.org
Subject: Re: Threaded Records in SQL: Advice Needed
Date: Mon, 10 Apr 2000 14:25:39 -0400
Message-ID: <200004101829.OAA62888@hub.org> (raw)
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: a222@redrose.net
Subject: Re: Threaded Records in SQL: Advice Needed
In-Reply-To: <200004101829.OAA62888@hub.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox