But yes the problem is not with FROM but with ORDER BY or GROUP BY.
As you can see in my query I need to GROUP BY modelloid ad aggregate
on npezzi. To solve the problem I rewrite the query in the second for and
encapsulated the subquery with GROUP BY in (). This for work without problem.
Bye Massimo Fidanza
2006/3/9, Tom Lane <[EMAIL PROTECTED]
>:
I wrote:
> "Massimo Fidanza" < [EMAIL PROTECTED]> writes:
>> this query is not correct and doesn't work with postgresql 8.1.
> It still works, if you enable add_missing_from.
I take that back --- FROM is not the issue (indeed, it has one).
The problem is the ORDER BY and LIMIT clauses. I dunno who put
in this example, but I'd like some of what they were smoking.
I've taken it out again, since without that it's not really showing
anything that the prior examples don't cover.
regards, tom lane
