=?utf-8?q?PG_Bug_reporting_form?= <noreply@postgresql.org> writes:
> When using COALESCE with an aggregate subquery to a CTE, NULL is returned
> instead of the first non-null value in the argument list. Proof-of-concept
> examples are below. I would expect COALESCE to return 0 in these cases. Am I
> missing something? Thanks.
Um ... I get zero from each of your test cases, in all PG versions back
to 9.3.
regards, tom lane