postgresql SearchVector error when try to add integerfield to it

[mickaelmarin]

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(searchicontains=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...