MIME-Version: 1.0
References: <4e7a338-c7d3-e944-20bd-a6e346e175c7@appl-ecosys.com>
 <C7F5BFD3-929B-46CC-B20C-893189F154D5@kleczek.org>
In-Reply-To: <C7F5BFD3-929B-46CC-B20C-893189F154D5@kleczek.org>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Tue, 4 Feb 2025 12:03:22 -0500
Message-ID: 
 <CANzqJaC83XvJOzCH+3Au5LgMOCMGMNXdTDLU6_tPJmLjO5rGZg@mail.gmail.com>
Subject: Re: Lookup tables
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000002e5569062d53fdac"
Archived-At: 
 <https://www.postgresql.org/message-id/CANzqJaC83XvJOzCH%2B3Au5LgMOCMGMNXdTDLU6_tPJmLjO5rGZg%40mail.gmail.com>
Precedence: bulk

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

On Tue, Feb 4, 2025 at 11:31=E2=80=AFAM Micha=C5=82 K=C5=82eczek <michal@kl=
eczek.org> wrote:
[snip]

>
> The query to register a visit is:
> insert into restaurant_visit
> select $user, current_date, restaurant_id, $rating
> from restaurant where name =3D $restaurant_name
>
>
> It is now completely unclear what it means to change the name of the
> restaurant for already registered visits.
> Is it still the same restaurant with a different name or a different
> restaurant?
>
> Or let say someone swaps names of two restaurants.
> That means a user that goes to the same restaurant every day would
> register visits to two different restaurants!
>

Valid concerns, which means that you add a new restaurant record when the
name changes.

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

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

<div dir=3D"ltr"><div dir=3D"ltr">On Tue, Feb 4, 2025 at 11:31=E2=80=AFAM M=
icha=C5=82 K=C5=82eczek &lt;<a href=3D"mailto:michal@kleczek.org">michal@kl=
eczek.org</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_contain=
er"><div>[snip]=C2=A0</div><blockquote class=3D"gmail_quote" style=3D"margi=
n:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex=
">
<br>
The query to register a visit is:<br>
insert into restaurant_visit<br>
select $user, current_date, restaurant_id, $rating<br>
from restaurant where name =3D $restaurant_name<br>
<br>
<br>
It is now completely unclear what it means to change the name of the restau=
rant for already registered visits.<br>
Is it still the same restaurant with a different name or a different restau=
rant?<br>
<br>
Or let say someone swaps names of two restaurants.<br>
That means a user that goes to the same restaurant every day would register=
 visits to two different restaurants!<br></blockquote><div></div></div><div=
><br></div><div>Valid concerns, which means that you add a new restaurant r=
ecord when the name changes.</div><div><br></div><span class=3D"gmail_signa=
ture_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div =
dir=3D"ltr">Death to &lt;Redacted&gt;, and butter sauce.<div>Don&#39;t boil=
 me, I&#39;m still alive.<br><div><div>&lt;Redacted&gt; lobster!</div></div=
></div></div></div></div>

--0000000000002e5569062d53fdac--