public inbox for [email protected]
help / color / mirror / Atom feedFrom: David G. Johnston <[email protected]>
To: o1bigtenor <[email protected]>
Cc: Ibrahim Shaame <[email protected]>
Cc: swastik Gurung <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Reporting by family tree
Date: Wed, 25 Oct 2023 15:16:54 -0700
Message-ID: <CAKFQuwZVgp_Lvc01RXN0sB3sGR=Zud0dKVST2x6jiMisTLnr2g@mail.gmail.com> (raw)
In-Reply-To: <CAPpdf59_++4MTbNaoUcNSSVKYfhF8Y683=bxCOkgydpw9unxKg@mail.gmail.com>
References: <CAJOWwD5M=YK9nKBX6TD-NB1B7Ddo6uLZC2fG1WAED86fg4s2oA@mail.gmail.com>
<[email protected]>
<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>
<[email protected]>
<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>
On Wed, Oct 25, 2023 at 9:13 AM o1bigtenor <[email protected]> wrote:
> On Wed, Oct 25, 2023 at 9:55 AM David G. Johnston
> <[email protected]> wrote:
> >
> > On Wed, Oct 25, 2023 at 5:21 AM Ibrahim Shaame <[email protected]>
> wrote:
> >>
> >> But what I want to get is grandfather - father - children:
> >>
> >> 1 - Grandfather1
> >>
> >> 3 - father1-1
> >>
> >> 6 - son1-1
> >>
> >> 7 – son1-2
> >>
> >> 4 - Father1-2
> >>
> >> 8 - son2-1
> >>
> >> 2 – Grandfather2
> >>
> >> 5 - Father2-1
> >>
> >> etc
> >>
> >>
> >> Any suggestion
> >>
> >
> > If you want a different ordering of the output change the ORDER BY
> specification.
> >
> > Specifically, you want to order by the path of each person. Since that
> can only be determined during the traversal you need to create the path
> data yourself. I suggest using an integer[] (integer array) to store the
> path 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 individuals
as their unique identifiers.
{1}
{1,3}
{1,3,6}
{1,3,7}
{1,4}
{1,4,8}
{2}
{2,5}
David J.
view thread (13+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: Reporting by family tree
In-Reply-To: <CAKFQuwZVgp_Lvc01RXN0sB3sGR=Zud0dKVST2x6jiMisTLnr2g@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox