On Fri, Sep 30, 2011 at 5:23 AM, Vitalii Tymchyshyn <tivv00@gmail.com> wrote:
> Since you are using except and not except all, you are not looking at arrays
> with duplicates.
> For this case next function what the fastest for me:
>
> create or replace function array_except2(anyarray,anyarray) returns
> anyarray as $$
> select ARRAY(
> (
> select r.elements
> from (
> (select 1,unnest($1))
> union all
> (select 2,unnest($2))
> ) as r (arr, elements)
> group by 1
> having min(arr)=max(arr)
> ))
> $$ language sql strict immutable;
>
I've been informed that this type of operation is called "symmetric
difference"[1], and can be represented by A ∆ B. A couple of
alternative names were proposed, "array_symmetric_difference" and
"array_xor".
Does anyone have a preference for the name? I assume that this
function might potentially be used by others now that it is in the pg
lists, so might as well give it an appropriate name now.
Is this something that could be written in C to make it faster (I don't know C)
[1] http://en.wikipedia.org/wiki/Symmetric_difference