Re: array_except -- Find elements that are not common to both arrays - Mailing list pgsql-performance

From Ben Chobot
Subject Re: array_except -- Find elements that are not common to both arrays
Date
Msg-id 531A6FA4-A1C1-459F-8B9E-217F9F39CB50@silentmedia.com
Whole thread Raw
In response to Re: array_except -- Find elements that are not common to both arrays  (bricklen <bricklen@gmail.com>)
Responses Re: array_except -- Find elements that are not common to both arrays  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-performance
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
goingto happen. 

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Shortcutting too-large offsets?
Next
From: Merlin Moncure
Date:
Subject: Re: array_except -- Find elements that are not common to both arrays