Re: Proposition to use '==' as synonym for 'IS NOT DISTINCT FROM' - Mailing list pgsql-hackers

From Isaac Morland
Subject Re: Proposition to use '==' as synonym for 'IS NOT DISTINCT FROM'
Date
Msg-id CAMsGm5e9z2Mp5iM7n7Et=Zwc7AOU0fw4kuAVSt8+tA+HdObNbw@mail.gmail.com
Whole thread Raw
In response to Re: Proposition to use '==' as synonym for 'IS NOT DISTINCT FROM'  (Eugen Konkov <kes-kes@yandex.ru>)
Responses Re: Proposition to use '==' as synonym for 'IS NOT DISTINCT FROM'  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On Mon, 28 Oct 2019 at 07:39, Eugen Konkov <kes-kes@yandex.ru> wrote:

If we should follow this form, then IS DISTINCT should be written as:
x =! y
This  looks unusual, because JavaScript also follow != form. so I hope
it  will be easy to detect/implement != form, which I used to read as:
negate the result of comparison

Postgres already allows != as a synonym for <>. I think having =! mean something subtly but significantly different is a terrible idea. At a minimum we would have to remove the synonym, which would be a backwards compatibility break. 

pgsql-hackers by date:

Previous
From: Eugen Konkov
Date:
Subject: Re: Proposition to use '==' as synonym for 'IS NOT DISTINCT FROM'
Next
From: Robert Haas
Date:
Subject: Re: [Proposal] Global temporary tables