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@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
