On Sun, 09 Oct 2016 12:40:09 -0400, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > Adrian Klaver <adrian.klaver@xxxxxxxxxxx> writes: >> On 10/09/2016 08:46 AM, Tom Lane wrote: >>> Clearly a bug --- the wrong type OIDs are being passed down to >>> array_append. It should be told that it's getting called as >> For my edification, why does this work?: > On closer inspection, the error is only in the > aggregate-used-as-window-function case, not plain aggregation. Yes, I see the same phenomenon. Could someone suggest a workaround until this is fixed? I'm under the gun to submit output tables and the only thing I can think of is a crawling slow loop to step through each window twice: once using the plain aggregation and another without just get all rows. I highly doubt it will be worthwhile, given it's going to be about 1000 iterations, and each one would take about 30-45 min... -- Seb -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
