Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5DET7E30797 for ; Wed, 13 Jun 2001 10:29:07 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.1/8.11.1) id f5DEKAx19345 for pgsql-sql@postgresql.org; Wed, 13 Jun 2001 10:20:10 -0400 (EDT) (envelope-from news) From: Vivek Khera X-Newsgroups: comp.databases.postgresql.sql Subject: Re: How to store a linked list in a RDBMS Date: 13 Jun 2001 10:20:05 -0400 Organization: Khera Communications, Inc., Rockville, MD Lines: 15 Message-ID: References: <20010613020819.84921.qmail@web14502.mail.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: scrappy@hub.org User-Agent: Gnus/5.0808 (Gnus v5.8.8) XEmacs/21.1 (Cuyahoga Valley) To: pgsql-sql@postgresql.org X-Archive-Number: 200106/196 X-Sequence-Number: 3452 >>>>> "SR" == Srikanth Rao writes: SR> I have a linked list representing a tree. How do I SR> store it in the database? Does PGSQL give us any SR> special procedures to deal with such structures? Pick up a data structures book and read up on how to implement a linked list inside an array. This maps directly to an SQL table with a sequential primary key. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D. Khera Communications, Inc. Internet: khera@kciLink.com Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/