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

Поиск
Список
Период
Сортировка
От Henry Drexler
Тема Re: plpgsql at what point does the knowledge of the query come in?
Дата
Msg-id CAAtgU9R44BtRn9unjwEBU+gLWGehu=BOy50+iwSvGrNk4f78AA@mail.gmail.com
обсуждение исходный текст
Ответ на plpgsql at what point does the knowledge of the query come in?  (Henry Drexler <alonup8tb@gmail.com>)
Ответы Re: plpgsql at what point does the knowledge of the query come in?
Список pgsql-general
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);
for i in 1..(nnlength-1) loop
select into t
node
from
(Values('threeee','N'),('threee',''),('fiveu','N'),('five',''))
blast(node,nmarker)
where node = substring(newnode,1,i-1)||substring(newnode,i+1,nnlength);
end loop;
return t;
END;
$$

select
node as node_orig,
nmarker,
nnodetestt(node),
case
when nmarker = 'N' then
nnodetestt(node)
end
from
(Values('threeee','N'),('threee',''),('fiveu','N'),('five',''))
blast(node,nmarker)

"threeee";"N";"threee";"threee"
"threee";"";"";""
"fiveu";"N";"";""
"five";"";"";""


В списке pgsql-general по дате отправления:

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: a set of key/value pairs
Следующее
От: Raymond O'Donnell
Дата:
Сообщение: Re: plpgsql at what point does the knowledge of the query come in?