Testing your branch, I get caught installing the DB with the following errors:
psql:080.schema.money.sql:222: ERROR: aggregate functions are not allowed in GROUP BY
LINE 36: COALESCE(SUM(debit.amount),0) - COALESCE(SUM(credit.amount... ^
psql:080.schema.money.sql:263: ERROR: syntax error at or near "last"
LINE 25: last(billing.btype) AS btype
I haven't done any troubleshooting of the first error yet, but the second error appears to be a missing comma.
Mike,
Testing your branch, I get caught installing the DB with the following errors:
psql:080. schema. money.sql: 222: ERROR: aggregate functions are not allowed in GROUP BY SUM(debit. amount) ,0) - COALESCE( SUM(credit. amount. ..
^ schema. money.sql: 263: ERROR: syntax error at or near "last"
LINE 36: COALESCE(
psql:080.
LINE 25: last(billing.btype) AS btype
I haven't done any troubleshooting of the first error yet, but the second error appears to be a missing comma.