Postgres Pro
Downloads
Home   >   mailing lists

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

From Vik Fearing
Subject Re: Proposition to use '==' as synonym for 'IS NOT DISTINCT FROM'
Date
Msg-id e7e56dfb-6cfd-8e5d-89c2-04427c77dcaa@2ndquadrant.com
Whole thread Raw
In response to 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'
List pgsql-hackers
Tree view 
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.

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Proposition to use '==' as synonym for 'IS NOT DISTINCT FROM'
Next
From: Andres Freund
Date:
Subject: Re: Proposition to use '==' as synonym for 'IS NOT DISTINCT FROM'