Re: plpgsql at what point does the knowledge of the query come in? - Mailing list pgsql-general

On 20/10/2011 21:51, Henry Drexler wrote:
> I found the problem, it looks like nnlength := length(newnode); is not
> getting reset
>
> create or replace function nnodetestt(text) returns text language
> plpgsql as $$
> DECLARE
> newnode alias for $1;
> nnlength integer;
> t text;
> nmarker text;
> BEGIN
> nnlength := length(newnode);

Not sure what you mean by the above... that statement only gets executed
once, so the value of nnlength doesn't change.

Ray.



--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie