Re: Keep specialized query pairs, or use single more general but more complex one

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"?


Cheers,
Greg

--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support