Re: plpgsql at what point does the knowledge of the query come in?

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 <rod(at)iol(dot)ie> wrote:

> On 20/10/2011 23:16, Henry Drexler wrote:
> >
> >
> > On Thu, Oct 20, 2011 at 5:41 PM, Raymond O'Donnell <rod(at)iol(dot)ie
> > <mailto:rod(at)iol(dot)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
> rod(at)iol(dot)ie
>