I’m trying to do a full text search with PostgreSQL. I receive a list of words and want to produce a query where each of them is wrapped in a
to_tsquery function, so the resulting query would look like:
SELECT "things"."id" FROM "things" WHERE ( ("things"."fulltext_index") @@ ( to_tsquery('simple', ''' ' || 'term1' || ' ''' || ':*') && to_tsquery('simple', ''' ' || 'term2' || ' ''' || ':*') && … to_tsquery('simple', ''' ' || 'termN' || ' ''' || ':*') ) )
The bummer is that the number of query terms is unknown, so I need to generate the string dynamically. I’ve tried iterating over the terms and using
fragment, but that gave me a confusing compilation error
… If you want to invoke Enum.reduce/2 in a query, make sure that the module Enum is required and that reduce/2 is a macro
Googling also didn’t give me any relevant results. So this is my last hope to figure it out. Could you guide me, please?
I would very much prefer not to change the query as I’m porting it from Rails code and the behavior must stay intact. But if this is not possible with Ecto, that would also be useful information.