Home > mailing lists

Re: Does Type Have = Operator? - Mailing list pgsql-hackers

From	David G. Johnston
Subject	Re: Does Type Have = Operator?
Date	May 11, 2016 04:28:15
Msg-id	CAKFQuwbCKYNVkxQwiN_onMggyqThUzX4ZjO-O2-EyXrcsU3p+Q@mail.gmail.com Whole thread Raw
In response to	Re: Does Type Have = Operator? (Euler Taveira <euler@timbira.com.br>)
Responses	Re: Does Type Have = Operator?
List	pgsql-hackers

On Tuesday, May 10, 2016, Euler Taveira <euler@timbira.com.br> wrote:

Also, IS DISTINCT FROM is an alias for = operator per standard IIRC.

Technically "is not distinct from" would be more correct. Alias implies exact while in the presence of nulls the two behave differently.

"is distinct from" ~ "<>" which is the canonical form (alias) for "!="

David J.

From: "David G. Johnston"
Date: 11 May 2016, 04:22:21
Subject: Re: Accurate list of Keywords / Datatypes?

From: Bruce Momjian
Date: 11 May 2016, 04:34:02
Subject: Re: release management team statement on patch reverts