X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 01BDB11F6228 for ; Tue, 25 Apr 2006 23:52:06 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 07522-01 for ; Tue, 25 Apr 2006 23:52:08 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from hub.org (hub.org [200.46.204.220]) by postgresql.org (Postfix) with ESMTP id 2313811F620C for ; Tue, 25 Apr 2006 23:52:05 -0300 (ADT) Received: from localhost (mx1.hub.org [200.46.208.251]) by hub.org (Postfix) with ESMTP id 9E62A291FE2 for ; Tue, 25 Apr 2006 23:52:00 -0300 (ADT) Received: from hub.org ([200.46.204.220]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 07233-01 for ; Tue, 25 Apr 2006 23:52:06 -0300 (ADT) Received: from ganymede.hub.org (blk-222-82-85.eastlink.ca [24.222.82.85]) by hub.org (Postfix) with ESMTP id 13506291FE0 for ; Tue, 25 Apr 2006 23:52:00 -0300 (ADT) Received: by ganymede.hub.org (Postfix, from userid 1000) id B59345C7FF; Tue, 25 Apr 2006 23:52:11 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id B496D5C7FE for ; Tue, 25 Apr 2006 23:52:11 -0300 (ADT) X-Return-Path: X-Received: from ganymede.hub.org ([unix socket]) by ganymede.hub.org (Cyrus v2.2.13) with LMTPA; Tue, 25 Apr 2006 23:35:18 -0300 X-Sieve: CMU Sieve 2.2 X-Received: from ganymede.hub.org (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id 8056F5C5EE for ; Tue, 25 Apr 2006 23:35:18 -0300 (ADT) X-Received: from mail.postgresql.org [200.46.204.71] by ganymede.hub.org with IMAP (fetchmail-6.3.2) for (single-drop); Tue, 25 Apr 2006 23:35:18 -0300 (ADT) X-Received: from postgresql.org ([unix socket]) by postgresql.org (Cyrus v2.2.12) with LMTPA; Tue, 25 Apr 2006 23:34:09 -0300 X-Sieve: CMU Sieve 2.2 X-Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id A30E511F60AE for ; Tue, 25 Apr 2006 23:34:09 -0300 (ADT) X-Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 02782-07 for ; Tue, 25 Apr 2006 23:34:10 -0300 (ADT) X-Received: from postgresql.org (postgresql.org [200.46.204.71]) by postgresql.org (Postfix) with ESMTP id D4C5011F60A9 for ; Tue, 25 Apr 2006 23:34:08 -0300 (ADT) X-Original-To: pgsql-sql-postgresql.org-owner@localhost.postgresql.org X-Delivered-To: pgsql-sql-postgresql.org-owner@localhost.postgresql.org X-Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id E648111F60A8 for ; Tue, 25 Apr 2006 23:34:07 -0300 (ADT) X-Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 02881-03 for ; Tue, 25 Apr 2006 23:33:59 -0300 (ADT) X-Greylist: delayed 00:48:46.691208 by SQLgrey- X-Received: from smtp4.pacifier.net (smtp4.pacifier.net [64.255.237.174]) by postgresql.org (Postfix) with ESMTP id DC88211F60A2 for ; Tue, 25 Apr 2006 23:33:57 -0300 (ADT) X-Received: from nefesh (ip16.gte154.dsl-acs2.sea.iinet.com [207.202.154.16]) by smtp4.pacifier.net (Postfix) with SMTP id 3125433202 for ; Tue, 25 Apr 2006 19:33:58 -0700 (PDT) From: "Ray Madigan" To: "Pgsql-Sql-Owner" Subject: Linked List Date: Tue, 25 Apr 2006 19:50:59 -0700 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Importance: Normal X-Virus-Scanned: Maia Mailguard 1.0.1 X-Virus-Scanned: Maia Mailguard 1.0.1 ReSent-Date: Tue, 25 Apr 2006 23:52:08 -0300 (ADT) ReSent-From: "Marc G. Fournier" ReSent-To: pgsql-sql@postgresql.org ReSent-Subject: [SQL]Linked List ReSent-Message-ID: <20060425235208.K34052@ganymede.hub.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/215 X-Sequence-Number: 25024 I have a table that I created that implements a linked list. I am not an expert SQL developer and was wondering if there are known ways to traverse the linked lists. The table contains many linked lists based upon the head of the list and I need to extract all of the nodes that make up a list. The lists are simple with a item and a link to the history item so it goes kind of like: 1, 0 3, 1 7, 3 9, 7 ... Any suggestions would be helpful, or I will have to implement the table differently. Thanks Ray Madigan