From: | Malix <malix0(at)gmail(dot)com> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #2303: UPDATE from manual is incorrect |
Date: | 2006-03-10 00:26:34 |
Message-ID: | 73eb2b3a0603091626n1c80d16t@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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(at)sss(dot)pgh(dot)pa(dot)us>:
>
> I wrote:
> > "Massimo Fidanza" <malix0(at)gmail(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Hodgson | 2006-03-10 00:43:59 | BUG #2311: Toast table chunk_id overflow |
Previous Message | eKo1 | 2006-03-09 20:24:20 | BUG #2310: "ALTER TYPE name OWNER TO new_owner" not working |