Possible bug in 9.3.17 using operator <>
<div dir='rtl'><div dir="ltr">The operator <> seems to not work properly comparing citext types in triggers function.</div>
<div dir="ltr"> </div>
<div dir="ltr"><a href="https://stackoverflow.com/questions/45441840/posgresql-9-3-operator-doesnt-give-logical-result">https://stackoverflow.com/questions/45441840/posgresql-9-3-operator-doesnt-give-logical-result</a></div>
<div dir="ltr"> </div>
<div dir="ltr">Can someone figure out what is the problem? This seems like a bug.</div></div>
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.https://stackoverflow.com/questions/45441840/posgresql-
9-3-operator-doesnt-give-logical-resultCan 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.