MIME-Version: 1.0
References: <CAFCRh-9SDUvcrF_RigOzXsbOm=8mHmzy2OSC1ejQNcjmfXXM_Q@mail.gmail.com>
In-Reply-To: <CAFCRh-9SDUvcrF_RigOzXsbOm=8mHmzy2OSC1ejQNcjmfXXM_Q@mail.gmail.com>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Mon, 24 Feb 2025 11:39:15 -0500
Message-ID: <CAKAnmmJeA-oXD-nOuqpi6EoSogmsgPAW-5puwN1scdc-snEC9g@mail.gmail.com>
Subject: Re: Keep specialized query pairs, or use single more general but more
 complex one
To: Dominique Devienne <ddevienne@gmail.com>
Cc: pgsql-general@lists.postgresql.org, andrew@tao11.riddles.org.uk
Content-Type: multipart/alternative; boundary="0000000000006aa9ca062ee5fd6a"
Archived-At: <https://www.postgresql.org/message-id/CAKAnmmJeA-oXD-nOuqpi6EoSogmsgPAW-5puwN1scdc-snEC9g%40mail.gmail.com>
Precedence: bulk

--0000000000006aa9ca062ee5fd6a
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Mon, Feb 24, 2025 at 4:46=E2=80=AFAM 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 =
=3D
> 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

--0000000000006aa9ca062ee5fd6a
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Mon, Feb 24, 2025 at 4:46=E2=80=AFAM D=
ominique Devienne &lt;<a href=3D"mailto:ddevienne@gmail.com">ddevienne@gmai=
l.com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_container">=
<blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-=
left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div>But=
 now we have a new requirement, for &quot;fuzzy find&quot;. I.e. the client=
 can ask for names</div><div>which are not the exact in-DB names, but also =
aliases of those names.</div></div></blockquote><div>...=C2=A0</div><blockq=
uote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1p=
x solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div>join unnes=
t($3::text[]) with ordinality as aliases(name, ord) on <a href=3D"http://c.=
name" target=3D"_blank">c.name</a> =3D <a href=3D"http://aliases.name" targ=
et=3D"_blank">aliases.name</a></div></div></blockquote><div><br></div><div>=
I&#39;m not seeing how this is supposed to work, if these aliases are not i=
n the database somewhere. Maybe an example? How does &quot;Alli&quot; get m=
apped to a=C2=A0<a href=3D"http://c.name">c.name</a> of &quot;Allison&quot;=
?</div><div><br></div><div>=C2=A0</div></div><div dir=3D"ltr" class=3D"gmai=
l_signature"><div dir=3D"ltr"><div>Cheers,</div><div>Greg</div><div><br></d=
iv><div>--</div><div>Crunchy Data - <a href=3D"https://www.crunchydata.com"=
 target=3D"_blank">https://www.crunchydata.com</a></div><div>Enterprise Pos=
tgres Software Products &amp; Tech Support</div><div><br></div></div></div>=
</div>

--0000000000006aa9ca062ee5fd6a--