On Sunday, May 6, 2018, Shay Rojansky <
roji@roji.org> wrote:
Comparison requires both things to be the same type. The rules for implicitly converting one type to another prefer the core type text over the extension type citext.
IOW, there is no such operator =(citext,text) and thus "citext = text comparison" is technically invalid.
At this point we're sorta stuck with our choice, and while individual databases can implement their own functions and operators there is value in doing things the way the system provides to minimize future confusion and bugs.
David J.