Postgres Pro
Downloads
Home   >   mailing lists

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

From David Rowley
Subject Re: add operator ^= to mean not equal (like != and <>)
Date
Msg-id CAApHDvo7VyYQ1S=gGuf-JTgqt6z2TN0an1S7td_CWC9PpE=nkA@mail.gmail.com
Whole thread Raw
In response to Re: add operator ^= to mean not equal (like != and <>)  (Daniel Gustafsson <daniel@yesql.se>)
Responses Re: add operator ^= to mean not equal (like != and <>)  (Daniel Gustafsson <daniel@yesql.se>)
List pgsql-hackers
Tree view 
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.

David

pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Skipping logical replication transactions on subscriber side
Next
From: Daniel Gustafsson
Date:
Subject: Re: add operator ^= to mean not equal (like != and <>)