Re: array_except -- Find elements that are not common to both arrays

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Fri, Sep 30, 2011 at 3:15 PM, Ben Chobot <bench@xxxxxxxxxxxxxxx> wrote:
>
> On Sep 30, 2011, at 12:07 PM, bricklen wrote:
>
>> 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)
>
> FWIW, speaking as somebody who has no need of this function, "array_xor" is a pretty clear name that indicates what's going to happen.

+1 on this -- was going to suggest until you beat me to it.  I also
for the record really think the array_ prefix on array handling
functions is pretty silly since we support overloading -- greatly
prefer unnest() to array_unnest() etc.  So, how about xor()?

merlin

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance



[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux