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

On Mar 1, 2010, at 9:15 AM, Michael Gould wrote:

>=20
> The following bug has been logged online:
>=20
> Bug reference:      5356
> Logged by:          Michael Gould
> Email address:      mgould@intermodalsoftwaresolutions.net
> PostgreSQL version: 8.4.2
> Operating system:   Windows 2008 R2 Server, Windows 7 x64
> Description:        citext not acting like case insensitive search
> Details:=20
>=20
> When we run the following query, we return no results.
>=20
> Select citystateinfoid from iss.citystateinfo where cityname =3D
> 'JACKSONVILLE' and statecode =3D 'FL';
>=20
> However this does work
>=20
> Select citystateinfoid from iss.citystateinfo where cityname =3D
> 'Jacksonville' and statecode =3D 'FL'
>=20
> The second query is how the data is actually stored.  I've already forwar=
ded
> our ddl to david wheeler.

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 n=
ot when they're in some other schema? Is `=3D` resolving to `TEXT =3D TEXT`=
 if the "iss" schema isn't in the search path?

Michael, does this work?

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

Best,

David