Content-Type: multipart/alternative;
 boundary=Apple-Mail-314D3A98-AE09-452F-B04E-20E8205153A5
Content-Transfer-Encoding: 7bit
From: Rob Sargent <robjsargent@gmail.com>
Mime-Version: 1.0 (1.0)
Subject: Re: One parent record with 3 possible child records
Date: Thu, 2 May 2024 12:28:42 -0600
Message-Id: <72955C51-7E22-4BA7-93C1-2C4D99D37ED9@gmail.com>
References: 
 <CAKFQuwY6-90W2sO=peE6xf1F07vpbf_4PdKa_bt=4=OAH1GMCw@mail.gmail.com>
Cc: pgsql-sql@postgresql.org, JORGE MALDONADO <jorgemal1960@gmail.com>
In-Reply-To: 
 <CAKFQuwY6-90W2sO=peE6xf1F07vpbf_4PdKa_bt=4=OAH1GMCw@mail.gmail.com>
To: "David G. Johnston" <david.g.johnston@gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/72955C51-7E22-4BA7-93C1-2C4D99D37ED9%40gmail.com>
Precedence: bulk


--Apple-Mail-314D3A98-AE09-452F-B04E-20E8205153A5
Content-Type: text/html;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html><head><meta http-equiv=3D"content-type" content=3D"text/html; charset=3D=
utf-8"></head><body dir=3D"auto"><div dir=3D"ltr"></div><div dir=3D"ltr">Got=
cha, thanks</div><div dir=3D"ltr"><br><blockquote type=3D"cite">On May 2, 20=
24, at 8:03=E2=80=AFAM, David G. Johnston &lt;david.g.johnston@gmail.com&gt;=
 wrote:<br><br></blockquote></div><blockquote type=3D"cite"><div dir=3D"ltr"=
>=EF=BB=BF<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" sty=
le=3D"font-family:arial,helvetica,sans-serif"><span style=3D"font-family:Ari=
al,Helvetica,sans-serif">On Thu, May 2, 2024 at 6:37=E2=80=AFAM Rob Sargent &=
lt;<a href=3D"mailto:robjsargent@gmail.com">robjsargent@gmail.com</a>&gt; wr=
ote:</span><br></div></div><div class=3D"gmail_quote"><blockquote class=3D"g=
mail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,=
204,204);padding-left:1ex"><div style=3D"overflow-wrap: break-word;"><div><b=
lockquote type=3D"cite">Presuming the id is unique in parent and child, what=
=E2=80=99s the value of the type field in the foreign key?&nbsp; Are you say=
ing the PK on tableMain is (type,id), perhaps for clustering purposes?<br></=
blockquote></div><div><br></div></div></blockquote><div><br></div><div class=
=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif">Preventi=
ng the parent record from saying "tblOne" while the actual ID value is prese=
nt on "tblTwo".</div><div class=3D"gmail_default" style=3D"font-family:arial=
,helvetica,sans-serif"><br></div><div class=3D"gmail_default" style=3D"font-=
family:arial,helvetica,sans-serif">David J.</div><div class=3D"gmail_default=
" style=3D"font-family:arial,helvetica,sans-serif"><br></div></div></div>
</div></blockquote></body></html>=

--Apple-Mail-314D3A98-AE09-452F-B04E-20E8205153A5--