Re: Subtract one array from another, both with non-unique elements

Поиск
Список
Период
Сортировка
От Alexander Farber
Тема Re: Subtract one array from another, both with non-unique elements
Дата
Msg-id CAADeyWiPW7KHBZ19K6-zOqc92ctncHH22v8VsSsJpgw10EA2JQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Subtract one array from another, both with non-unique elements  (bricklen <bricklen@gmail.com>)
Ответы Re: Subtract one array from another, both with non-unique elements  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-general
Дерево обсуждения
Thank you, but shouldn't I better use FOREACH for my task?

On Sun, Mar 6, 2016 at 6:34 PM, bricklen <bricklen@gmail.com> wrote:
On Sun, Mar 6, 2016 at 9:22 AM, Alexander Farber <alexander.farber@gmail.com> wrote:
could someone please recommend the most efficient way subtracting elements of one array from the other in PostgreSQL 9.5?

There are quite a few examples of array functions at http://postgres.cz/wiki/Array_based_functions, probably worth having a look.

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

Предыдущее
От: bricklen
Дата:
Сообщение: Re: Subtract one array from another, both with non-unique elements
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: Subtract one array from another, both with non-unique elements