Postgres Pro
Downloads
Home   >   mailing lists

Chain/Thread Problem - Mailing list pgsql-sql

From sammynash@uboot.com (Sammy)
Subject Chain/Thread Problem
Date
Msg-id 6729af8d.0305160646.d9ab2d2@posting.google.com
Whole thread Raw
Responses Re: Chain/Thread Problem  (Richard Huxton <dev@archonet.com>)
List pgsql-sql
Tree view 
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
(3rdin 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,

pgsql-sql by date:

Previous
From: Mike Winter
Date:
Subject: Efficiency Issue with "SELECT IN (..)" and "SELECT .. OR .."
Next
From: "J Sensel"
Date:
Subject: Re: Chain/Thread Problem