| From: | Daniel Gustafsson <daniel(at)yesql(dot)se> |
|---|---|
| To: | David Rowley <dgrowleyml(at)gmail(dot)com> |
| Cc: | Andreas Karlsson <andreas(at)proxel(dot)se>, "孙诗浩(思才)" <sunshihao(dot)ssh(at)alibaba-inc(dot)com>, "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: add operator ^= to mean not equal (like != and <>) |
| Date: | 2021-08-10 10:41:15 |
| Message-ID: | 122F740E-6843-4373-B92F-339673AF4B54@yesql.se |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> On 10 Aug 2021, at 12:21, David Rowley <dgrowleyml(at)gmail(dot)com> wrote:
>
> On Tue, 10 Aug 2021 at 21:13, Daniel Gustafsson <daniel(at)yesql(dot)se> wrote:
>>
>>> On 10 Aug 2021, at 11:10, Andreas Karlsson <andreas(at)proxel(dot)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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Julien Rouhaud | 2021-08-10 10:42:29 | Re: add operator ^= to mean not equal (like != and <>) |
| Previous Message | David Rowley | 2021-08-10 10:21:04 | Re: add operator ^= to mean not equal (like != and <>) |