Re: Recursive functions with SPL

From: Gabriele Bartolini <g.bartol@comune.prato.it> > > Is it possible to create a recursive function with Stored >Procedures Language? Yes. > I got this problem. I have a gerarchical relation between >records of the same table, like a tree. I got to perform a posticipate >view of the tree, retrieving the relationship (parent and son) >existing between all these entries. > >The record structure is: > ID > Description > ParentID (if 0 is at the top). > >Do you have any examples? No. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com