Juergen wrote: > 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
Look at the CONNECT BY built-in function. Daniel Morgan ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
