[SQL] PL/PGSQL Cook Book

2001-02-09 Thread plpgsql
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

[SQL] Recusrive Functions in 7.0.3

2001-02-09 Thread plpgsql
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

Re: [SQL] What's wrong with this function

2001-02-09 Thread plpgsql
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