I have in my Postgres Database a product with following tupple:
(description_de='Elegante Bluse',title_de='Elegante
Bluse,slug='elegante-bluse')
Not i have a field for a fulltextsearch over this table. I try to filtering
by:
When i now search after "Elegante" it works perfect but when i search after
"bluse" no result.
Here are query with searchtext "Bluse":
SELECT description_de,title_de,slug, to_tsvector(german::regconfig,
COALESCE("catalogue_product"."title_de", ) || ' ' ||
COALESCE("catalogue_product"."description_de", ) || ' ' ||
COALESCE("catalogue_product"."slug", )) AS "search" FROM
"catalogue_product" WHERE UPPER(to_tsvector(german::regconfig,
COALESCE("catalogue_product"."title_de", ) || ' ' ||
COALESCE("catalogue_product"."description_de", ) || ' ' ||
COALESCE("catalogue_product"."slug", ))::text) LIKE UPPER(%Bluse%) ORDER BY
"catalogue_product"."date_created" DESC
I have no idea whats happen here. Have someone a idea?
Regards
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/8d8f5f14-3585-41a4-bb56-88b1c8305631n%40googlegroups.com.
