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	postgresql SearchVector error when try to add integerfield to it	mickaelmarin	nobody	"Hi,

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...


"	Uncategorized	new	Uncategorized	1.11	Normal				Unreviewed	0	0	0	0	0	0