sum error

[PongraczIstvan]

Hi!

if I run the below code then I get unexpected error

const tr = await pool.getDatabase();

const sql='select fok_tetel.fok1 FOK, sum(fok_tetel.osszeg) osszeg from fok_tetel
group by fok_tetel.fok1 '; const param: any[] = []; const result = await tr.query(sql, param,true); console.log(result);

if I use min, max or avg function , then it perfect...

[PongraczIstvan]

if I use cast() for the osszeg field then it is all OK ...

const sql='select fok_tetel.fok1 FOK, cast(sum(fok_tetel.osszeg) as numeric(15,2)) osszeg from fok_tetel group by fok_tetel.fok1 ';

[arthurprezottoandrade]

Man, you have no idea how much you helped me, my sincere thanks

[mreis1]

This should also work:

const sql='select fok_tetel.fok1 FOK, sum(fok_tetel.osszeg * 1.00) osszeg from fok_tetel group by fok_tetel.fok1