Re: aggregate function ? - Mailing list pgsql-novice

From Richard Broersma Jr
Subject Re: aggregate function ?
Date
Msg-id 332348.8019.qm@web31804.mail.mud.yahoo.com
Whole thread Raw
In response to aggregate function ?  (Raimon Fernandez <coder@montx.com>)
Responses Re: aggregate function ?
List pgsql-novice
oops I just found a mistake in the query...

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



pgsql-novice by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: aggregate function ?
Next
From: Raimon Fernandez
Date:
Subject: Re: aggregate function ?