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:
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.
Based on that message, it sounds like you tried code with a line like where: Enum.reduce(...). Building the fragment outside the Ecto macro plumbing may make things clearer.
Could you show an example of what you mean? Because if I’m not mistaken, calling fragment outside of the Ecto’s scope also gave some error like it’s not defined.
The name does sound like it could be it, but I wasn’t able to figure out how to use it for my case. From the examples it seems it doesn’t work with strings. If you have used it for a similar purpose, I’d be grateful if you shared a sketch of the code.