Re: custom average window function failure - Mailing list pgsql-general

From Tom Lane
Subject Re: custom average window function failure
Date
Msg-id 19183.1476027964@sss.pgh.pa.us
Whole thread Raw
In response to custom average window function failure  (Seb <spluque@gmail.com>)
Responses Re: custom average window function failure  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Seb <spluque@gmail.com> writes:
> Any thoughts on what has changed that is leading to this failure?

Clearly a bug --- the wrong type OIDs are being passed down to
array_append.  It should be told that it's getting called as

    (angle_vectors[], angle_vectors) returns angle_vectors[]

but what it's actually getting told is

    (vector, angle_vectors) returns vector

which naturally makes it spit up because "vector" isn't an array type.
I don't think control ever reaches your custom finalfunc at all.

Probably somebody fat-fingered this while refactoring code in the
aggregate/windowfunction area.  Possibly me :-(.  Haven't found
exactly where things are going off the rails, but it's clearly
a PG bug.  Thanks for the report!

            regards, tom lane


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: custom average window function failure
Next
From: Adrian Klaver
Date:
Subject: Re: custom average window function failure