Okay I have a similar but seemingly more complicated Problem with aggregate
values in an UPDATE statement:
update test set ew_data_vm_fraction =
array_agg(unnest(ew_data_vm) * area_percentage)
gives me the obvious "ERROR: cannot use aggregate function in UPDATE"
message
when I set i in parentheses
update test set ew_data_vm_fraction =
(select array_agg(unnest(ew_data_vm) * area_percentage)
from test
it results in the message: "ERROR: set-valued function called in context
that cannot accept a set"
i am really desperate,what can I try else?
Greeting
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Putting-an-aggregate-value-in-an-UPDATE-statement-tp2140836p5531159.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.