When I was doing the mockups in excel using mid as a substitute for postgres substitute, I had to do -1 but that was actually not necessary as it was shorting the values, so the corrected plpgsql has the line
nnlength := length(newnode); instead of nnlength := length(newnode)-1; On Fri, Oct 21, 2011 at 6:10 AM, Raymond O'Donnell <r...@iol.ie> wrote: > On 20/10/2011 23:16, Henry Drexler wrote: > > > > > > On Thu, Oct 20, 2011 at 5:41 PM, Raymond O'Donnell <r...@iol.ie > > <mailto:r...@iol.ie>> wrote: > > > > > > Are you sure about this? Try using RAISE NOTICE statements in the > > function to output the value of nnlength each time it's executed. > > > > Ray. > > > > > > Thank you for showing me the 'Rase Notice' , I had not seen that before > > and it helped me solve my problem right away. > > Glad you got sorted. What was the problem in the end? > > Ray. > > > -- > Raymond O'Donnell :: Galway :: Ireland > r...@iol.ie >
