Re: plpgsql FOR LOOP CTE problem ? - Mailing list pgsql-general

From Tom Lane
Subject Re: plpgsql FOR LOOP CTE problem ?
Date
Msg-id 18584.1376058010@sss.pgh.pa.us
Whole thread Raw
In response to plpgsql FOR LOOP CTE problem ?  ("Day, David" <dday@redcom.com>)
Responses Re: plpgsql FOR LOOP CTE problem ?  ("Day, David" <dday@redcom.com>)
Re: plpgsql FOR LOOP CTE problem ?  ("Day, David" <dday@redcom.com>)
List 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 by date:

Previous
From: "ascot.moss@gmail.com"
Date:
Subject: Re: Recovery.conf and PITR by recovery_target_time
Next
From: Paula Kirsch
Date:
Subject: bi-directional syncing help request