On Fri, Sep 30, 2011 at 5:23 AM, Vitalii Tymchyshyn <tivv00@xxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
