hi there. Has anyone ever managed to make fulltext...
# random
m
hi there. Has anyone ever managed to make fulltextsearch preview feature working with pg? No matter how I create the index, the client seemingly sends in the request with
Copy code
WHERE to_tsvector(concat_ws(' ', "test"."Test"."barcode")) @@ to_tsquery($1)
instead of the index created for this pupose. is this intentional and the pg should solve the query planning? or i am missing something in the docs?
d
I made a library just to mitigate this issue, it's called Prisma Util and comes with built-in support for
pg_trgm
. The way it works is that I build the queries from scratch in a middleware, so it uses the index.