On Tue, Dec 20, 2005 at 06:58:41PM +0100, Klein Bal?zs wrote: > In practice however this doesn?t seem to work as the function never returns. > > Should this work in theory? Is this the recommended approach? I can' think of any reason why it wouldn't work; have you tried adding RAISE statements to see what's actually happening? Also, you should look at contrib/ltree; it might be a better way to do what you're trying to do. Celko's book SQL For Smarties also has some different ways to store hierarchies; unfortunately it's not handy or I could give you some google search terms, but the book's worthy buying anyway. Apparently he's also got a book that's dedicated to hierarchies and graphs, but I don't know how good it is. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
