Re: custom average window function failure
| От | Tom Lane |
|---|---|
| Тема | Re: custom average window function failure |
| Дата | |
| Msg-id | 19183.1476027964@sss.pgh.pa.us обсуждение исходный текст |
| Ответ на | custom average window function failure (Seb <spluque@gmail.com>) |
| Ответы |
Re: custom average window function failure
|
| Список | 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 по дате отправления: