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 eAEKnAs59848 for ; Tue, 14 Nov 2000 15:49:10 -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 VAA27368 for ; Tue, 14 Nov 2000 21:47:54 +0100 Message-ID: <3A11A5EF.C74A40EE@merz-akademie.de> Date: Tue, 14 Nov 2000 21:51:59 +0100 From: Alvar Freude Organization: http://a-blast.org/ X-Mailer: Mozilla 4.7 [de] (WinNT; I) X-Accept-Language: de MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Using Array-Values in subselect Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200011/112 X-Sequence-Number: 143 Hi, i want to create a linked structure of values. Each text has an id, an array of children ids and the value itself. CREATE TABLE structure ( id int8, children int8[], value text ); Now i want to select all values which are connected to a given parent #x at once. My first idea was this: SELECT value FROM structure WHERE id IN (SELECT children FROM structure WHERE id = #x); But this causes an error because the array field just returns a string instead of seperated values. Is there a way to make arrays return sort of "real arrays" or something usable in a subselect in reasonable speed? Thank you 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