Re: recursive function

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(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461