id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
12583	Postgresql backend uses implicit text casts for case insensitive operators	Ubercore	Ubercore	"In django.db.backends.postgresql.operations.DatabaseOperations, a case insensitive lookup produces

{{{
UPPER(%s::text)
}}}

as the lookup cast sql.

In django.db.backends.postgresql.DatabaseWrapper.operators, a case insensitive lookup produces

{{{
UPPER(%s)
}}}

Since Postgres 8.3 removed implicit casts, all operators should use ::text. Not doing so breaks lookups that use a type other than text:

{{{
AModel.objects.filter(col1__iexact=4)
}}}
"	Bug	closed	Database layer (models, ORM)	dev	Normal	worksforme	postgresql cast case-insensitive	kwadrat	Accepted	1	0	0	1	0	0