Context Navigation

Changes between Initial Version and Version 1 of Ticket #29582

Timestamp:: Jul 20, 2018, 2:42:42 PM (6 years ago)
Author:: Tim Graham
Comment:: The problem seems to be hardcoded Value(''), regardless of the field type. I'm not sure what the proper resolution is.

Ticket #29582
- Property Component Uncategorized → contrib.postgres
- Property Triage Stage Unreviewed → Accepted
- Property Summary postgresql SearchVector error when try to add integerfield to it → SearchVector doesn't support querying non-text fields
- Property Type Uncategorized → Bug

-              initial
+              v1
-Hi,
 I try to implement autocomplete on my place table that look like below:
 **  class Place(models.Model):
+{{{
+class Place(models.Model):
     name = models.CharField(max_length=80, blank=True)
     num = models.IntegerField(null=True)
 …
         address = "{0}, {1}, {2}, {3}".format(self.num, self.street,
                                               self.postal_code, self.city, self.country)
         return address**
+        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)**
+{{{
+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...
+}}}