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?
If no one is ma
If I remove the line calling PERFORM it works without problems moving the children
node for the passed integer into test and then exiting.
I can then repeat the process going through the output to test iteratively and do not
have any problems.
However if I put the PERFORM line back in to create
Ahh I found what I was doing wrong, there was a rogue value being returned causing to
infinite loop. Its fixed now.
Creating that script you recommended set my thinking process straight.
many thanks
Mark
On Saturday 10 February 2001 08:42, Tom Lane wrote:
> mark proctor <[EMAIL PRO
the select query returns the first row to rec. You can then access its values with:
rec.field_name
at END LOOP it jumps back to FOR checks to see if there any more rows and if so moves
to the next row and repeats the loop.
It also looks like your missing a LOOP keyword at the end of the FOR line
