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

From: Vik Fearing <vik(dot)fearing(at)2ndquadrant(dot)com>
To: Eugen Konkov <kes-kes(at)yandex(dot)ru>, PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: Proposition to use '==' as synonym for 'IS NOT DISTINCT FROM'
Date: 2019-10-26 23:09:29
Message-ID: e7e56dfb-6cfd-8e5d-89c2-04427c77dcaa@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 26/10/2019 17:41, Eugen Konkov wrote:
> Hi.
>
> I have noticed that it would be cool to use '==' in place of 'IS NOT
> DISTICT FROM'
>
> What do you think about this crazy idea?

I think this is a terrible idea.  The only reason to do this would be to
index it, but indexes (btree at least) expect STRICT operators, which
this would not be.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2019-10-26 23:21:47 Re: Proposition to use '==' as synonym for 'IS NOT DISTINCT FROM'
Previous Message Tom Lane 2019-10-26 21:18:09 Re: pg_dump compatibility level / use create view instead of create table/rule