Re: Proposition to use '==' as synonym for 'IS NOT DISTINCT FROM'

From: Isaac Morland <isaac(dot)morland(at)gmail(dot)com>
To: Eugen Konkov <kes-kes(at)yandex(dot)ru>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, David Fetter <david(at)fetter(dot)org>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Proposition to use '==' as synonym for 'IS NOT DISTINCT FROM'
Date: 2019-10-28 11:54:32
Message-ID: CAMsGm5e9z2Mp5iM7n7Et=Zwc7AOU0fw4kuAVSt8+tA+HdObNbw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, 28 Oct 2019 at 07:39, Eugen Konkov <kes-kes(at)yandex(dot)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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2019-10-28 12:07:07 Re: [Proposal] Global temporary tables
Previous Message Eugen Konkov 2019-10-28 11:39:38 Re: Proposition to use '==' as synonym for 'IS NOT DISTINCT FROM'