"David E. Wheeler" <david(at)kineticode(dot)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