I've just spent the last day or two trying to get to grips with plpgsql and can't
believe how abysmal the documetentation and examples are.
I've been trawling through the mailist lists and I notice there was talk back in 1999
abouta PLPGSQL Cook Book - did anything come of this
Are recursive functions allowed in in 7.0.3 as I seem to be unable to get them to work
in plpgsql, it just freezes and I have to do ctrl-alt-c.
ie calling the same function name from within some form of loop, possible to 4 or 5
levels?
Also is it possible to output any debugging info, all I
test (node1, node2) VALUES(stm.node_child, .rec.node_parent);
END LOOP;
RETURN 0;
END;
'LANGUAGE 'plpgsql'
Mark
On Saturday 10 February 2001 18:04, Najm Hashmi wrote:
> Hi all,
> Here is a plpgsql function:
> flipr'#create function test_cur() returns