Re: plpgsql FOR LOOP CTE problem ?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: plpgsql FOR LOOP CTE problem ?
Дата
Msg-id 18584.1376058010@sss.pgh.pa.us
обсуждение исходный текст
Ответ на plpgsql FOR LOOP CTE problem ?  ("Day, David" <dday@redcom.com>)
Ответы Re: plpgsql FOR LOOP CTE problem ?  ("Day, David" <dday@redcom.com>)
Re: plpgsql FOR LOOP CTE problem ?  ("Day, David" <dday@redcom.com>)
Список pgsql-general
"Day, David" <dday@redcom.com> writes:
> Looking at  the outermost for loop of the function below,  If I run this CTE query from the psql command line
> I am returned what I expect for values  for translator_id and the
> Aggregating MIN functions. I restore the experimental data and now run the function.
> In the context of this function I get a valid  translator_id ,
> But the MINed columns are NULL ????

Perhaps those column names duplicate variable names within the function,
and what's being returned is the values of the variables?

If you think there's a bug here, you'd need to provide a self-contained
test case.

            regards, tom lane


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

Предыдущее
От: "ascot.moss@gmail.com"
Дата:
Сообщение: Re: Recovery.conf and PITR by recovery_target_time
Следующее
От: Paula Kirsch
Дата:
Сообщение: bi-directional syncing help request