Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 266CE475DD7
	for <pgsql-sql@postgresql.org>; Tue, 28 Jan 2003 10:55:57 -0500 (EST)
Received: from news.hub.org (news.hub.org [64.49.215.80])
	by postgresql.org (Postfix) with ESMTP id 54A62476581
	for <pgsql-sql@postgresql.org>; Tue, 28 Jan 2003 10:45:20 -0500 (EST)
Received: by news.hub.org (Postfix, from userid 8)
	id 65A5143B022; Tue, 28 Jan 2003 10:45:06 -0500 (EST)
From: jasche@gmx.de (Juergen)
X-Newsgroups: comp.databases.theory, comp.databases.rdb,
	comp.databases.postgresql.sql, comp.databases.oracle.misc
Subject: double linked list
Date: 28 Jan 2003 07:44:29 -0800
Organization: http://groups.google.com/
Lines: 39
Message-ID: <2ee07259.0301280744.582e4b7c@posting.google.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Complaints-To: groups-abuse@google.com
To: pgsql-sql@postgresql.org
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200301/461
X-Sequence-Number: 11326

Hi folks!,

I've got a table called 'link_t' containing a collection of seller -
buyer relations between two parties.

sql> select * from link_t

S B
- -
C X
A B
B C
C D
D E

5 rows selected.

I am looking for a select statement that returns the concatenation of
seller - buyer relations between the first seller 'A' and the last
buyer 'B'.

the result should be

S B
- -
A B
B C
C D
D E

Currently I fumbling around with self joins but haven't figured out
yet.
Any suggestions

Many tanks in advance

Cheers

Juergen