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
29582	SearchVector doesn't support querying non-text fields	mickaelmarin	nobody	"I try to implement autocomplete on my place table that look like below:
{{{
class Place(models.Model):
    name = models.CharField(max_length=80, blank=True)
    num = models.IntegerField(null=True)
    street = models.CharField(max_length=100, blank=True)
    postal_code = models.IntegerField(null=True)
    district = models.CharField(max_length=30, blank=True)
    city=models.CharField(max_length=30, blank=True)
    country = models.CharField(max_length=30, blank=True)
    domicile = models.BooleanField(default=False)

    def __str__(self):
        address = ""{0}, {1}, {2}, {3}"".format(self.num, self.street, 
                                              self.postal_code, self.city, self.country)
        return address
}}}
and in my function that return the result for display my address on frontend is like (self.q is a GET param from ajax call):

{{{
qs = Place.objects.all()
qs.annotate(search=SearchVector('street', 'country','city', 'num')).filter(search__icontains=self.q)
}}}
I have this error when the ajax call run:
{{{
  File ""/opt/coupdepouce/lib/python3.6/site-packages/django/db/backends/utils.py"", line 64, in execute
    return self.cursor.execute(sql, params)
django.db.utils.DataError: invalid input syntax for integer: """"
LINE 1: ...city"", '') || ' ' || COALESCE(""user_place"".""num"", '')) AS ""s...
}}}"	Bug	closed	contrib.postgres	dev	Normal	fixed			Ready for checkin	1	0	0	0	0	0