Re: add operator ^= to mean not equal (like != and <>) - Mailing list pgsql-hackers

From Daniel Gustafsson
Subject Re: add operator ^= to mean not equal (like != and <>)
Date
Msg-id 122F740E-6843-4373-B92F-339673AF4B54@yesql.se
Whole thread Raw
In response to Re: add operator ^= to mean not equal (like != and <>)  (David Rowley <dgrowleyml@gmail.com>)
Responses Re: add operator ^= to mean not equal (like != and <>)
List pgsql-hackers
> On 10 Aug 2021, at 12:21, David Rowley <dgrowleyml@gmail.com> wrote:
>
> On Tue, 10 Aug 2021 at 21:13, Daniel Gustafsson <daniel@yesql.se> wrote:
>>
>>> On 10 Aug 2021, at 11:10, Andreas Karlsson <andreas@proxel.se> wrote:
>>
>>> What is he reason you want to add ^= is there any other databases which uses ^= for inequality?
>>
>> I assume it's because of Oracle compatibility which AFAIK is the only database
>> supporting ^=.
>
> Seems likely.
>
> I'm strongly against inheriting warts from Oracle for apparently good
> reason. At the very least, anyone who's using ^= for some other
> purpose is very likely to be upset with us. Anyone else who really
> needs this for compatibility reasons can just create a set of
> operators for themselves.

Agreed, if it’s because of Oracle compatibility then this seems like something
which has a better fit in orafce or a similar extension like that.

--
Daniel Gustafsson        https://vmware.com/




pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: add operator ^= to mean not equal (like != and <>)
Next
From: Julien Rouhaud
Date:
Subject: Re: add operator ^= to mean not equal (like != and <>)