Re: GroupAggregate and Integer Arrays

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: GroupAggregate and Integer Arrays
Дата
Msg-id CAMkU=1wS2ioBvb67zbqdu7TnH=-_x+3c9s88icrjWqts2_hBUA@mail.gmail.com
обсуждение исходный текст
Ответ на GroupAggregate and Integer Arrays  (David Osborne <david@qcode.co.uk>)
Ответы Re: GroupAggregate and Integer Arrays  (David Osborne <david@qcode.co.uk>)
Список pgsql-performance
Дерево обсуждения
On Fri, Oct 23, 2015 at 7:29 AM, David Osborne <david@qcode.co.uk> wrote:
 
Hi,

Wondering if anyone could suggest how we could improve the performance of this type of query?
The intensive part is the summing of integer arrays as far as I can see.


Postgres does not ship with any 'sum' function which takes array arguments.

> select sum('{1,2,3,4,5,6}'::int[]);

ERROR:  function sum(integer[]) does not exist

Are you using a user defined function?  If so, how did you define it?

Cheers,

Jeff

В списке pgsql-performance по дате отправления:

Предыдущее
От: David Osborne
Дата:
Сообщение: GroupAggregate and Integer Arrays
Следующее
От: David Osborne
Дата:
Сообщение: Re: GroupAggregate and Integer Arrays