From dea55eaad449d0dbfdd7a14b4d1000182a7032c9 Mon Sep 17 00:00:00 2001 From: Vincent Le Gallic Date: Mon, 29 Feb 2016 03:04:41 +0100 Subject: [PATCH] [transactions.sh] On veut voir leur type --- bde/transactions.sh | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/bde/transactions.sh b/bde/transactions.sh index 088ec5c..21fb7e7 100755 --- a/bde/transactions.sh +++ b/bde/transactions.sh @@ -5,7 +5,7 @@ export LESS='-S' psql note -c " - SELECT t.id, t.date, + SELECT t.id, t.date, t.type, 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 -- 2.39.2