On 12/5/20 8:14 AM, ha...@datasundae.com wrote:
I tried the COALESCE approach but I thought the query still returned (None,).
From docs:
https://www.postgresql.org/docs/12/functions-conditional.html#FUNCTIONS-COALESCE-NVL-IFNULL
"The COALESCE function returns the first of its arguments that is not
null. Null is returned only if all arguments are null. ..."
So if it returned NULL/None then the first and second values both
resolved to NULL.
However, I just tried it again and I got a (Decimal('0'),) return.
I should be able to make that work.
Thanks everyone for your rapid assistance.
Best,
Hagen
--
Adrian Klaver
adrian.kla...@aklaver.com
