On Tue, Aug 1, 2017 at 8:39 AM, Nick Dro <postgre...@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-result > > 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.