Home -> Usenet -> comp.databases.theory -> Recursive closure

Recursive closure

From: Tim Galle <38726_at_stud.ehsal.be>
Date: Wed, 04 Jul 2001 22:40:22 GMT
Message-ID: <qXM07.16840$YS5.1992966_at_afrodite.telenet-ops.be> 






I have a table with a recursive relation.  Something like:
tblName(Number (PK), Name, SuperNumber (FK) )



I would like to create a query who gives all the names at all the levels.
(number differs from record to record) You can't do that in SQL2,
but I heared it was possible in SQL3.



How do you write this in relational algebra?



Does someone know where I could find this information?



tia


Tim
Received on Thu Jul 05 2001 - 00:40:22 CEST












Original text of this message