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

Поиск
Список
Период
Сортировка
От Isaac Morland
Тема Re: Proposition to use '==' as synonym for 'IS NOT DISTINCT FROM'
Дата
Msg-id CAMsGm5e9z2Mp5iM7n7Et=Zwc7AOU0fw4kuAVSt8+tA+HdObNbw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Proposition to use '==' as synonym for 'IS NOT DISTINCT FROM'  (Eugen Konkov <kes-kes@yandex.ru>)
Ответы Re: Proposition to use '==' as synonym for 'IS NOT DISTINCT FROM'  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Дерево обсуждения
On Mon, 28 Oct 2019 at 07:39, Eugen Konkov <kes-kes@yandex.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. 

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

Предыдущее
От: Eugen Konkov
Дата:
Сообщение: Re: Proposition to use '==' as synonym for 'IS NOT DISTINCT FROM'
Следующее
От: Robert Haas
Дата:
Сообщение: Re: [Proposal] Global temporary tables