- # Bon, le grep est pourri, mais la version de bde de egrep fait de la merde
- psql bde -c "SELECT sum(solde) FROM adherents adh,inscriptions ins WHERE adh.numcbde=ins.adherent AND annee=$i AND solde<0${cond};" | grep \\.
- psql bde -c "SELECT sum(solde) FROM adherents adh,inscriptions ins WHERE adh.numcbde=ins.adherent AND annee=$i AND solde>0${cond};" | grep \\.
+ psql note -c "SELECT sum(solde) FROM comptes c, adhesions a WHERE c.idbde = a.idbde AND a.annee = $i AND solde < 0${cond};" | grep -v ligne | grep -E '[0-9]'
+ psql note -c "SELECT sum(solde) FROM comptes c, adhesions a WHERE c.idbde = a.idbde AND a.annee = $i AND solde > 0${cond};" | grep -v ligne | grep -E '[0-9]'