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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/8d8f5f14-3585-41a4-bb56-88b1c8305631n%40googlegroups.com.
