- ,array_accum(race::text) AS race
- ,array_accum(amount) AS amount
- ,array_accum(eta) AS eta
- ,array_accum(shiptype) AS shiptype
+ ,array_accum(COALESCE(race::text,'')) AS race
+ ,array_accum(COALESCE(amount,0)) AS amount
+ ,array_accum(COALESCE(eta,0)) AS eta
+ ,array_accum(COALESCE(shiptype,'')) AS shiptype