Hello, I'm want to use functionality of postgresql module pg_trgm<http://www.postgresql.org/docs/9.1/static/pgtrgm.html>in django. pg_trgm uses special operator % (percent sign). I don't know how should I escape it in query extra method.
# pure SQL SELECT content, similarity(content, 'string') AS sml FROM table WHERE content % 'str' ORDER BY sml DESC, content; # This throws exception IndexError 'tuple index out of range' # I tried to escape percent sign with %%, or \%, but I always get same exception objects = MyModel.objects.extra( select={'rank': 'similarity(content, %s)'}, select_params=[content], where='content % %s', params=[content], order_by=['-rank'] ) # Raw query works ok objects = MyModel.objects.raw('''SELECT *, similarity(content, %s) AS sml FROM table WHERE content %% %s ORDER BY sml DESC''', [content, content]) Can you help me how write percent sign in extra() method? Thank you -- You received this message because you are subscribed to the Google Groups "Django users" group. To view this discussion on the web visit https://groups.google.com/d/msg/django-users/-/N7BT4BFV11oJ. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.