Phong & Ronni Bounmixay <bounmixay(at)gmail(dot)com> writes:
> I want to do in postgresql what I do in oracle:
> select year report_year,
> sum(amount),
> sum(select amount from my_table where year <= report_year)
> from my_table
> group by report_year;
That doesn't really work in Oracle does it? It violates the SQL spec
in at least three ways. Try something like
select year as report_year,
sum(amount),
sum((select amount from my_table b where b.year <= a.year))
from my_table a
group by year;
(which should work in Oracle too, or any other SQL-spec-compliant
database). Note the extra parentheses ... they're not optional.
regards, tom lane