Hi
I created my own aggregate function working as max(sum(value))
It adds positive and negative values and finds maximum of this sum.
To work properly this function needs data to be sorted.
select maxsum(value)
from some_table order by some_field
doesn't work:
ERROR: Attribute some_table.some_field must be GROUPed or used in an
aggregate function
I found I can obey this using subselect:
select maxsum(X.value)
from (select value from some_table order by some_field) X
I can't create subselect, because I want to change this query into a
view. In my case postgresql doesn't use indexes on subselect inside a view.
What should I do?
Regards,
Tomasz Myrta