Received: from sleepy.usu.edu (sleepy.usu.edu [129.123.1.85]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eAELGBs61786 for ; Tue, 14 Nov 2000 16:16:12 -0500 (EST) (envelope-from rmello@cc.usu.edu) Received: from cc.usu.edu ("port 2989"@slxwy.dorms.usu.edu [129.123.236.160]) by cc.usu.edu (PMDF V5.2-32 #39375) with ESMTP id <01JWJ7EX62LW90N53D@cc.usu.edu> for pgsql-sql@postgresql.org; Tue, 14 Nov 2000 14:14:59 MST Date: Tue, 14 Nov 2000 14:15:11 -0700 From: Roberto Mello Subject: Re: Using Array-Values in subselect To: Alvar Freude Cc: pgsql-sql@postgresql.org Message-id: <3A11AB5F.C3F2C467@cc.usu.edu> MIME-version: 1.0 X-Mailer: Mozilla 4.75 [en] (X11; U; Linux 2.2.16 i586) Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7bit X-Accept-Language: en, pt-BR References: <3A11A5EF.C74A40EE@merz-akademie.de> X-Archive-Number: 200011/113 X-Sequence-Number: 144 Alvar Freude wrote: > > Hi, > > i want to create a linked structure of values. Each text has an id, an > array of children ids and the value itself. Looks like you want something similar to Oracle's CONNECT BY statement. There are some solutions to that. At OpenACS we had to deal with that so implemented something like what you described here. However, the methods described by Joe Celko is his book "SQL For Smarties" on chapters 28 and 29 (I think) are better and more robust. If you search for "trees" and related topics at the openacs.org and arsdigita.com's web/db web bulletin boards, you'll find several hits. -Roberto Mello P.S: I know this doesn't directly anwser your question, but points you to where to find the answer for yourself. -- Computer Science Utah State University Space Dynamics Laboratory Web Developer USU Free Software & GNU/Linux Club http://fslc.usu.edu My home page - http://www.brasileiro.net/roberto