Re: Does Type Have = Operator?

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Does Type Have = Operator?
Дата
Msg-id CAKFQuwbCKYNVkxQwiN_onMggyqThUzX4ZjO-O2-EyXrcsU3p+Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Does Type Have = Operator?  (Euler Taveira <euler@timbira.com.br>)
Ответы Re: Does Type Have = Operator?  (Euler Taveira <euler@timbira.com.br>)
Список 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 "!="

http://www.postgresql.org/docs/9.5/interactive/functions-comparison.html

David J.


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Accurate list of Keywords / Datatypes?
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: release management team statement on patch reverts