"Oscar Chavarria" <cyberbuzzard(at)gmail(dot)com> writes:
> yield_rows investments%rowtype;
> FOR yield_rows IN SELECT * FROM investments
I think you want "yield_rows" not "investments" here, no?
> *ERROR: missing FROM-clause entry for table "investments"*
Also, you should have gotten a more specific error message than that.
Wasn't there a "context" line telling you exactly which line of the
function contained the problem?
regards, tom lane
In response to
pgsql-novice by date
|Next:||From: kvnsmnsn||Date: 2007-04-10 19:35:55|
|Subject: trying to connect to PostgreSQL|
|Previous:||From: Stephan Szabo||Date: 2007-04-09 14:32:13|
|Subject: Re: Function problem|