On Jan 10, 2006, at 8:32 , Tom Lane wrote:
> Attached is a proposed change to create hopefully-more-useful error
> messages in the cases where we currently say "missing FROM-clause
> entry".
It's good to have these hints for users. Thanks, Tom.
> Patch:
> regression=# select * from a,b join c on (a.aa = c.cc);
> ERROR: invalid reference to FROM-clause entry for table "a"
> HINT: There is an entry for "a", but it cannot be referenced from
> this part of the query.
For clarity, I'd rewrite this hint as
There is an entry for table "a", ...
Michael Glaesemann
grzm myrealbox com