sum((CASE WHEN $1 = emetteur THEN (CASE WHEN $1 = destinataire THEN 0 ELSE -1 END) ELSE 1 END)*montant*quantite) OVER (ORDER BY date ASC) AS soldeapres,
t.quantite, t.montant, t.description, t.valide, t.emetteur, t.destinataire,
adhe.pseudo AS emetteur, adhd.pseudo AS destinataire
sum((CASE WHEN $1 = emetteur THEN (CASE WHEN $1 = destinataire THEN 0 ELSE -1 END) ELSE 1 END)*montant*quantite) OVER (ORDER BY date ASC) AS soldeapres,
t.quantite, t.montant, t.description, t.valide, t.emetteur, t.destinataire,
adhe.pseudo AS emetteur, adhd.pseudo AS destinataire