The exact issue is described here. The sum function of Postgres can return several data types, which is not taken into account when executing the aggregate function.

The exact issue lies in the PostgresRow+Database.swift at line 42, where the sum is always decoded to an Int? even though a Double may be returned from the aggregate function.

Postgress Aggregate Functions