i’d like to use <full-text search> on a postgres `...
# orm-help
j
i’d like to use full-text search on a postgres
jsonb
column. prisma doesn’t seem to support this, although postgres does, giving good results is this coming any time soon? or, failing that, is there any way to add something like this to a
.findMany
without rewriting all my queries in raw sql (since they’re already quite big and complex):
Copy code
SELECT * FROM "Work"

WHERE to_tsvector(answers) @@ websearch_to_tsquery('my search phrase');