Re: aggregate function ? - Mailing list pgsql-novice

--- Raimon Fernandez <coder@montx.com> wrote:

> but If I send the code that you send me, it takes too much .... well,
> more than 20 minutes and still waiting ...

just for testing try this version again so see if it preforms much better, then see if the summing
results are correct according to what you need.

    SELECT A1.oid, A1.concepte, A1.deure, A1.haver,
           sum( COALESCE( A1.deure, 0 ) - COALESCE( A2.haver, 0 )) AS value_sum
      FROM Assentaments AS A1
INNER JOIN Assentaments AS A2
        ON A1.oid <= A2.oid
     WHERE A1.numero=11189
  GROUP BY A1.oid, A1.concepte, A1.deure, A1.haver
  ORDER BY A1.oid;