Postgres Pro
Downloads
Home   >   mailing lists

Re: Subtract one array from another, both with non-unique elements - Mailing list pgsql-general

From Alexander Farber
Subject Re: Subtract one array from another, both with non-unique elements
Date
Msg-id CAADeyWiPW7KHBZ19K6-zOqc92ctncHH22v8VsSsJpgw10EA2JQ@mail.gmail.com
Whole thread Raw
In response to Re: Subtract one array from another, both with non-unique elements  (bricklen <bricklen@gmail.com>)
Responses Re: Subtract one array from another, both with non-unique elements  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: bricklen
Date:
Subject: Re: Subtract one array from another, both with non-unique elements
Next
From: Pavel Stehule
Date:
Subject: Re: Subtract one array from another, both with non-unique elements