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

Hi

2016-03-06 18:41 GMT+01:00 Alexander Farber <alexander(dot)farber(at)gmail(dot)com>:

> Thank you, but shouldn't I better use FOREACH for my task?
>
>
SQL based solution (functional based) solution can be faster and shorter.
PLpgSQL is nice language, but what you can do about arrays functionally,
you should to do :). Usually it is significantly faster.

But, you can try - it is good example for learning, try to implement it
different ways and compare speed.

Pavel

>
> On Sun, Mar 6, 2016 at 6:34 PM, bricklen <bricklen(at)gmail(dot)com> wrote:
>
>> On Sun, Mar 6, 2016 at 9:22 AM, Alexander Farber <
>> alexander(dot)farber(at)gmail(dot)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.
>>
>
>