Re: SQL Question

Posted in 2003

Obnoxio The Clown — Thu, 06 Nov 2003 16:10:10 +0000 — source: Usenet: comp.databases.informix

Mark Townsend wrote: > >> Unfortunately no other SQL implementation has added that feature so >> you'll have >> to implement it in code in you app or in an SPL. > > Hmm - well, IBM DB2 HAS implemented recursive common table expressions > (which IS in the standard and IS potentially a better implementation > that what we implemented in Oracle many,many years ago). Of course, I > don't believe that Informix has implemented this yet. > > How's that for truth in advertising ? Apart from the Node DataBlade, not too bad. > Recursive CTE's are actually pretty cool - see > http://www7b.software.ibm.com/dmdd/library/techarticle/0307steinbach/0307steinbach.html#section1 > for a discussion of them, and how they relate to Oracle's CONNECT BY > capabilities. -- Ciao, The Obnoxious One "Ogni uomo mi guarda come se fossi una testa di cazzo"