MIME-Version: 1.0
References: 
 <CAJOWwD5M=YK9nKBX6TD-NB1B7Ddo6uLZC2fG1WAED86fg4s2oA@mail.gmail.com>
 <1901532185.8873313.1696511707263@mail.yahoo.com>
 <CAJOWwD7YmD8jPediD7qG49vq9mtTbJOx3eAV4a9234RTJe_aHw@mail.gmail.com>
 <CAKFQuwaMRJUpMz8Usd3XHfymgdR=51G-CjOpi16nxWh+kytD0Q@mail.gmail.com>
 <CAJOWwD6ED658ZAg80YK85sFq=vObnrj6f086tNug6C8=K7wn3w@mail.gmail.com>
 <CAKFQuwYn6MfTyjpDraVqW7TfnCh2Q3-DvfEYHz+vifXvzpr_FA@mail.gmail.com>
 <1653003450.12126241.1697462972371@mail.yahoo.com>
 <CAJOWwD46a+JVtnWkpNHs3ZDrEF7onrG39WryKm6X_rP=t7SHyg@mail.gmail.com>
 <CAJOWwD6pJocMJtNiR5nay2XX4dWDtj-WDwv4xgE7Lc+DymWO0g@mail.gmail.com>
 <CAKFQuwamjM=d9RHDc+OHEkeWiCGpQJL=sMSxJ_tzwETrx=75Ww@mail.gmail.com>
 <CAPpdf59_++4MTbNaoUcNSSVKYfhF8Y683=bxCOkgydpw9unxKg@mail.gmail.com>
 <CAKFQuwZVgp_Lvc01RXN0sB3sGR=Zud0dKVST2x6jiMisTLnr2g@mail.gmail.com>
In-Reply-To: 
 <CAKFQuwZVgp_Lvc01RXN0sB3sGR=Zud0dKVST2x6jiMisTLnr2g@mail.gmail.com>
From: o1bigtenor <o1bigtenor@gmail.com>
Date: Thu, 26 Oct 2023 06:46:18 -0500
Message-ID: 
 <CAPpdf5-Bticw_wk_ZZiV2i7-sex87zEQoDojPsZc51-XMvtnMw@mail.gmail.com>
Subject: Re: Reporting by family tree
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: Ibrahim Shaame <ishaame@gmail.com>,
 swastik Gurung <gurung_swastik@yahoo.com>,
	"pgsql-novice@lists.postgresql.org" <pgsql-novice@lists.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: 
 <https://www.postgresql.org/message-id/CAPpdf5-Bticw_wk_ZZiV2i7-sex87zEQoDojPsZc51-XMvtnMw%40mail.gmail.com>
Precedence: bulk

On Wed, Oct 25, 2023 at 5:17=E2=80=AFPM David G. Johnston
<david.g.johnston@gmail.com> wrote:
>
> On Wed, Oct 25, 2023 at 9:13=E2=80=AFAM o1bigtenor <o1bigtenor@gmail.com>=
 wrote:
>>
>> On Wed, Oct 25, 2023 at 9:55=E2=80=AFAM David G. Johnston
>> <david.g.johnston@gmail.com> wrote:
>> >
>> > On Wed, Oct 25, 2023 at 5:21=E2=80=AFAM Ibrahim Shaame <ishaame@gmail.=
com> wrote:
>> >>
>> >> But what I want to get is  grandfather - father - children:
>> >>
>> >> 1 - Grandfather1
>> >>
>> >> 3 - father1-1
>> >>
>> >> 6 - son1-1
>> >>
>> >> 7 =E2=80=93 son1-2
>> >>
>> >> 4 - Father1-2
>> >>
>> >> 8 - son2-1
>> >>
>> >> 2 =E2=80=93 Grandfather2
>> >>
>> >> 5 - Father2-1
>> >>
>> >> etc
>> >>
>> >>
>> >> Any suggestion
>> >>
>> >
>> > If you want a different ordering of the output change the ORDER BY spe=
cification.
>> >
>> > Specifically, you want to order by the path of each person.  Since tha=
t can only be determined during the traversal you need to create the path d=
ata yourself.  I suggest using an integer[] (integer array) to store the pa=
th using ID values as breadcrumbs.
>> >
>> >
>> (Not the OP just someone following the list trying to learn.)
>>
>> 'using ID values as breadcrumbs' - - - can I interpret that to mean
>> the ordinal numbers 1-8 listed (more implied)?
>>
>
> Yes, the numbers 1-8 are the values assigned to these 8 example individua=
ls as their unique identifiers.
>
> {1}
> {1,3}
> {1,3,6}
> {1,3,7}
> {1,4}
> {1,4,8}
> {2}
> {2,5}
>

Thank you Mr David.