"David E. Wheeler" <da...@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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
