On 10/17/16 11:29 AM, Tom Lane wrote:
Jim Nasby <jim.na...@bluetreble.com> writes:
On 10/16/16 3:13 PM, Tom Lane wrote:
Related to this I'd also like to add a boolean XOR operator as that's a
relatively common request/question.

We have boolean XOR; it's spelled "<>".

I always forget about that...

Maybe it should be mentioned explicitly in the docs.

Hrm, went to go add it and it appears we don't have a section for boolean type operators. I guess I should add it to 9.1?

though, it doesn't work for boolean arrays.

Define doesn't work?

I would expect array[true, false] XOR array[true, true] to return array[false, true], but <> just returns a single true (since the arrays are !=).

Though, I guess what would make the most sense there is a map function that would apply an operator or function to every element of a set of arrays. But I don't see any way to do that without major changes to how anyarray works.
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532)   mobile: 512-569-9461

Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:

Reply via email to