Re: plpgsql FOR LOOP CTE problem ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Day, David" <dday(at)redcom(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: plpgsql FOR LOOP CTE problem ?
Date: 2013-08-09 14:20:10
Message-ID: 18584.1376058010@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Day, David" <dday(at)redcom(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Basavaraj 2013-08-09 14:20:47 Here is my problem
Previous Message ascot.moss@gmail.com 2013-08-09 14:17:50 Re: Recovery.conf and PITR by recovery_target_time