On Mon, Feb 24, 2025 at 4:46 AM Dominique Devienne <ddevienne@gmail.com> wrote:
But now we have a new requirement, for "fuzzy find". I.e. the client can ask for names
which are not the exact in-DB names, but also aliases of those names.
...
join unnest($3::text[]) with ordinality as aliases(name, ord) on c.name = aliases.name
I'm not seeing how this is supposed to work, if these aliases are not in the database somewhere. Maybe an example? How does "Alli" get mapped to a c.name of "Allison"?
