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 CAAtgU9Q-vHuJpEAUT4Pg-MBiDo7foGiv1c8mSwLNyaq+ZTXu_w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: plpgsql at what point does the knowledge of the query come in?  (Raymond O'Donnell <rod@iol.ie>)
Ответы Re: plpgsql at what point does the knowledge of the query come in?
Список pgsql-general
On Thu, Oct 20, 2011 at 4:57 PM, Raymond O'Donnell <rod@iol.ie> wrote:

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

Ray.


doesn't the function get executed once for each row in the query?
so in the below example
threeee will match threee
but fiveu will not match five because it has not reset  nnlength := length(newnode); to measure the length of fiveu but is retaining the length of threeee

is it possible to get nnlength := length(newnode); to reset for each new row/node in the query?

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

Предыдущее
От: "J.V."
Дата:
Сообщение: Re: how to disable all pkey/fkey constraints globally
Следующее
От: Henry Drexler
Дата:
Сообщение: Re: plpgsql at what point does the knowledge of the query come in?