On Thu, Oct 20, 2011 at 4:57 PM, Raymond O'Donnell <r...@iol.ie> wrote:
> > Not sure what you mean by the above... that statement only gets executed > once, so the value of nnlength doesn't change. > > Ray. doesn't the function get executed once for each row in the query? so in the below example threeee will match threee but fiveu will not match five because it has not reset nnlength := length(newnode); to measure the length of fiveu but is retaining the length of threeee is it possible to get nnlength := length(newnode); to reset for each new row/node in the query?