Re: add operator ^= to mean not equal (like != and <>)

Поиск
Список
Период
Сортировка
От Daniel Gustafsson
Тема Re: add operator ^= to mean not equal (like != and <>)
Дата
Msg-id 122F740E-6843-4373-B92F-339673AF4B54@yesql.se
обсуждение исходный текст
Ответ на Re: add operator ^= to mean not equal (like != and <>)  (David Rowley <dgrowleyml@gmail.com>)
Ответы Re: add operator ^= to mean not equal (like != and <>)  (Julien Rouhaud <rjuju123@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: add operator ^= to mean not equal (like != and <>)
Следующее
От: Julien Rouhaud
Дата:
Сообщение: Re: add operator ^= to mean not equal (like != and <>)