Re: BUG #5356: citext not acting like case insensitive search

"David E. Wheeler" <david@kineticode.com> writes:
> Michael managed to fix this issue by moving citext to the "public"
> schema. The question is, why would citext operators work in the public
> schema but not when they're in some other schema?

Are they in the search path?

> Michael, does this work?

> Select citystateinfoid from iss.citystateinfo where cityname iss.=
> 'JACKSONVILLE' and statecode iss.= 'FL';

The syntax is OPERATOR(iss.=) not just iss.= ...

            regards, tom lane