On Mon, Feb 24, 2025 at 4:46 AM Dominique Devienne <ddevienne@xxxxxxxxx> wrote:
But now we have a new requirement, for "fuzzy find". I.e. the client can ask for nameswhich 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"?
Cheers,
Greg
--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support
