Received: from localhost.localdomain (coyote@00-50-ba-d7-cd-46.bconnected.net [209.53.23.106]) by hub.org (8.10.1/8.10.1) with ESMTP id e6IFqw016742 for ; Tue, 18 Jul 2000 11:53:02 -0400 (EDT) Received: from smartt.com (IDENT:DrFrog@localhost.localdomain [127.0.0.1]) by localhost.localdomain (8.9.3/8.9.3) with ESMTP id JAA01078 for ; Tue, 18 Jul 2000 09:05:50 -0700 From: drfrog@smartt.com Message-ID: <3974805D.6C33895E@smartt.com> Date: Tue, 18 Jul 2000 09:05:49 -0700 X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.14-5.0 i586) X-Accept-Language: en MIME-Version: 1.0 To: "pgsql-sql@postgresql.org" Subject: using a self referencing table Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200007/175 i have a table with this structure name (varchar)|category id (int4)|parent category id (int4)|leaf node (bool) im trying to make a perl script that should tree the info parent cat subcat subcat2 subcat2 subcat subcat2 ... but im having troubles wrapping my head around this im using the Pg modules to access postgres if anyone has any suggestions please lemme know thanks!