Обсуждение: [HACKERS] Possible bug in 9.3.17 using operator <>

Поиск
Список
Период
Сортировка

[HACKERS] Possible bug in 9.3.17 using operator <>

От
Nick Dro
Дата:
The operator <> seems to not work properly comparing citext types in triggers function.
 
 
Can someone figure out what is the problem? This seems like a bug.

Re: [HACKERS] Possible bug in 9.3.17 using operator <>

От
"David G. Johnston"
Дата:
On Tue, Aug 1, 2017 at 8:39 AM, Nick Dro <postgresql@walla.co.il> wrote:
The operator <> seems to not work properly comparing citext types in triggers function.
 
 
Can someone figure out what is the problem? This seems like a bug.

Um, 'jack' and 'Jack' and indeed equal when compared case-insensitively.  You've asked whether they are unequal.  Since they are equal the answer to your question is "no" (false).  That is the answer you were given.

David J.