I’m using Manticore for autocompletion and I need only unique results.
But it returns all matching results which often repeat.
Simple SELECT DISTINCT name FROM my_table
doesn’t work.
Is there any way to fetch only unique results? I searched through all the docs and forum and couldn’t find any solution.