def lookup_cast(self, lookup_type):
        lookup = '%s'

        # Cast text lookups to text to allow things like filter(x__contains=4)
        if lookup_type in ('iexact', 'contains', 'icontains', 'startswith',
                           'istartswith', 'endswith', 'iendswith'):
            lookup = "%s::text"

        # Use UPPER(x) for case-insensitive lookups; it's faster.
        if lookup_type in ('iexact', 'icontains', 'istartswith', 'iendswith'):
            lookup = lookup % 'UPPER(%s)'

        return lookup
dataset/ETHPy150Open dcramer/django-compositepks/django/db/backends/postgresql/operations.py/DatabaseOperations.lookup_cast/swapped operands of `%`