David Fetter <david(at)fetter(dot)org> writes:
> While testing the upcoming FILTER clause for aggregates, Erik Rijkers
> uncovered a long-standing bug in $subject, namely that this case
> wasn't handled. Please find attached a patch by Andrew Gierth and
> myself which fixes this issue and adds a regression test to ensure it
> remains fixed.
I don't find this patch to be a good idea.
The argument for it seems to be that
array_agg(a COLLATE "C" ORDER BY b COLLATE "POSIX")
should not throw an error, but why not? And what does that have to do
with whacking around the code for CASE?
regards, tom lane