Received: from hub.org.org (localhost [127.0.0.1]) by hub.org (8.10.1/8.11.0) with SMTP id e9NKT6N35801 for ; Mon, 23 Oct 2000 16:29:06 -0400 (EDT) (envelope-from pgsql-sql-owner@hub.org) Received: from jennifer.emc.com.ph (una-jennifer.emc.com.ph [208.232.224.3]) by hub.org (8.10.1/8.11.0) with ESMTP id e9KAsDJ63388 for ; Fri, 20 Oct 2000 06:54:27 -0400 (EDT) (envelope-from pgsql-sql@fc.emc.com.ph) Received: from fc.emc.com.ph (fc.emc.com.ph [208.232.224.197]) by jennifer.emc.com.ph (Postfix) with ESMTP id 4ACB6D7A1 for ; Fri, 20 Oct 2000 18:48:52 +0800 (PST) Message-id: Date: Fri, 20 Oct 2000 18:48:54 +0800 Subject: help on creating table To: pgsql-sql@postgresql.org From: "pgsql-sql" MIME-Version: 1.0 Content-type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Archive-Number: 200010/195 X-Sequence-Number: 1857 Hi All, I'm planning to have data in a tree structure when fetched. e.g. NODE1 + --- NODE1_1 + --- NODE1_2 | + --- NODE1_2_1 + --- NODE1_3 Is this possible? How? I would really appreciate any help. Sherwin