Horton

Re: Reporting by family tree

David G. Johnston <david.g.johnston@gmail.com>

View thread View on postgr.es
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Ibrahim Shaame <ishaame@gmail.com>
Cc: swastik Gurung <gurung_swastik@yahoo.com>, "pgsql-novice@lists.postgresql.org" <pgsql-novice@lists.postgresql.org>
Date: 2023-10-25T14:54:42Z
Lists: pgsql-novice 
On Wed, Oct 25, 2023 at 5:21 AM 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 – 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.

David J.