Search Postgresql Archives

Re: plpgsql FOR LOOP CTE problem ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"Day, David" <dday@xxxxxxxxxx> 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


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux