Re: BUG #2303: UPDATE from manual is incorrect

Excuse me if I was no very clear and I don't put you in right direction,
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 <tgl@sss.pgh.pa.us>:
>
> I wrote:
> > "Massimo Fidanza" <malix0@gmail.com> 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
>