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

[Henry Drexler <alonup8tb@xxxxxxxxx>]

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@xxxxxx> wrote:

On 20/10/2011 23:16, Henry Drexler wrote:
>
>
> On Thu, Oct 20, 2011 at 5:41 PM, Raymond O'Donnell <rod@xxxxxx

> <mailto:rod@xxxxxx>> 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@xxxxxx