The following bug has been logged online:
Bug reference: 5385
Logged by: Corin
Email address: wakath...@gmail.com
PostgreSQL version: 8.4.2
Operating system: ubuntu amd64
Description:gd disallows agg function in subselect of update
Details:
query:
UPDATE imagecontes
Sorry, stupid me - it's not a bug, pg is perfectly right!
The query was just wrong, because I used the wrong column in the
SUM(...) function.
Sorry again,
Corin
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mai
Corin writes:
> Sorry, stupid me - it's not a bug, pg is perfectly right!
> The query was just wrong, because I used the wrong column in the
> SUM(...) function.
Yah. The reason the error message was phrased that way is that the SUM
argument is a variable of the outer query, so the aggregate is
