From: sammynash@uboot.com
To: pgsql-sql@postgresql.org
Subject: Chain/Thread Problem
Date: 16 May 2003 07:46:43 -0700
Message-ID: <6729af8d.0305160646.d9ab2d2@posting.google.com> (raw)
Hi,
I have a SQL problem for you all. What SQL qurey would I have to make
on the following table to extract the chain (thread) of emails in a
conversation.
id|emailid|referenceid
-----------------------
1| e125 | Null (Start of chain)
2| r1fe | e125 (2nd letter in chain)
...
...
n| e4ju | r1fe (3rd in chain)
ie
a sucessulf qurey would return rows 1,2 & n because they are all in
the chain.
Hope you can help me with my problem,
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: sammynash@uboot.com
Subject: Re: Chain/Thread Problem
In-Reply-To: <6729af8d.0305160646.d9ab2d2@posting.google.com>
* 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