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 aggregateon npezzi. To solve the problem I rewrite the query in the second for and
encapsulated the
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 wh
"Massimo Fidanza" <[EMAIL PROTECTED]> writes:
> The query is the last but one
> UPDATE employees SET last_closed_deal = deal.id
> FROM accounts JOIN deals ON (account.id = deal.account_id)
> WHERE deal.employee_id = employees.id
> AND deal.name = 'Rocket Powered Skates'
> AND accou
The following bug has been logged online:
Bug reference: 2303
Logged by: Massimo Fidanza
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1
Operating system: Linux
Description:UPDATE from manual is incorrect
Details:
Hi all, I have an update similar to the one
