Received: from student.merz-akademie.de (73.ptr.merz-akademie.de [195.226.105.73] (may be forged)) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eBF2bt059085 for ; Thu, 14 Dec 2000 21:37:55 -0500 (EST) (envelope-from alvar.freude@merz-akademie.de) Received: from merz-akademie.de (news.merz-akademie.de [195.226.105.70]) by student.merz-akademie.de (8.9.3/8.9.3) with ESMTP id DAA16405; Fri, 15 Dec 2000 03:38:17 +0100 Message-ID: <3A398526.3C491E91@merz-akademie.de> Date: Fri, 15 Dec 2000 03:42:46 +0100 From: Alvar Freude Organization: http://a-blast.org/ X-Mailer: Mozilla 4.7 [de] (WinNT; I) X-Accept-Language: de,en MIME-Version: 1.0 To: miguel sofer , pgsql-sql@postgresql.org Subject: Re: How to represent a tree-structure in a relationaldatabase References: <3A379A5F.97FFAF01@joerdens.de> <20001213.19440200@ant.utdt> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200012/153 X-Sequence-Number: 487 Hi, miguel sofer wrote: > > I once started writing a small paper on this subject; it is still in a > rather preliminary state. > > You can download the draft (and some ill documented code, 53kB) from > http://www.utdt.edu/~mig/sql-trees ah, this looks very, very nice! on page 5ff you describe the Postgres implementation, but the URL (page 5 bottom) is't complete -- can i find the files somewhere? Included is a "tree_general.sql", but this seems not to be complete and not the same version as the ps-file (First draft, may 6, 2000): in the draft there is written about an base 160 encoding, tree_general.sql uses base 159 encoding ;) Ciao Alvar -- Alvar C.H. Freude | alvar.freude@merz-akademie.de Demo: http://www.online-demonstration.org/ | Mach mit! Blast-DE: http://www.assoziations-blaster.de/ | Blast-Dich-Fit Blast-EN: http://www.a-blast.org/ | Blast/english