Re: [Dbmail-dev] threading queries - how to make a tree or graph

2005-08-17 Thread Paul J Stevens
Geo Carncross wrote: > Now that I'm awake (somewhat) I'll try and write this :) thanks > http://web.archive.org/web/20030629195428/http://www.cs.dartmouth.edu/~apd/archives/19.html > http://www.dbazine.com/oracle/or-articles/tropashko4 > http://article.gmane.org/gmane.comp.db.sqlite.general

Re: [Dbmail-dev] threading queries - how to make a tree or graph

2005-08-17 Thread Geo Carncross
Now that I'm awake (somewhat) I'll try and write this :) I'm aware of two algorithms basic for making a tree/graph in SQL. The first takes advantage of modular exponentation. I've seen varients using log and COMPLEX and whathaveyou- but this works on most SQL engines: http://web.archive.org/web

Re: [Dbmail-dev] threading queries

2005-08-16 Thread Paul J Stevens
Geo, I'll take your word for it: only REFERENCES threading. -- Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands__

Re: [Dbmail-dev] threading queries

2005-08-16 Thread Geo Carncross
Don't implement ORDEREDSUBJECT. There aren't any non-broken clients that use it. Implement both threading models the same way- clients that use the THREAD commands don't check the results to see if they used the specific algorithm- and it's a good thing too, because few servers implement this corre

[Dbmail-dev] threading queries

2005-08-15 Thread Paul J Stevens
Hi all, I could use some help here... My next target will be server-side threading. All the basics are in place, but now I need to figure out some smart queries to get this going. I'v got this so far: get the basic ORDEREDSUBJECT threads for a mailbox: select message_idnr, datefield, subject