MIME-Version: 1.0
In-Reply-To: 
 <CAJOWwD78ii+PBVNBuDmkz=n-n6WDA4CN+_WLBQ7WcbzGPdWBrw@mail.gmail.com>
References: 
 <CAJOWwD615LZV9+cppcVdajXJpn25VnjCmymMZrQxdwpfU9Ccsg@mail.gmail.com>
 <CAF5nyP9q=dFFtVm13Ni_sWOj-EY3cKRcZWEVbB=vLXbQ0j+wvQ@mail.gmail.com>
 <CAJOWwD78ii+PBVNBuDmkz=n-n6WDA4CN+_WLBQ7WcbzGPdWBrw@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Sat, 25 Nov 2023 07:02:44 -0700
Message-ID: 
 <CAKFQuwY9L7Dqvd9qqQCfyHF5o5As+skVEzsHf_2z_td9GG=NBA@mail.gmail.com>
Subject: Re: reporting tree into separate columns
To: Ibrahim Shaame <ishaame@gmail.com>
Cc: Didier Gasser-Morlay <didiergm@gmail.com>,
	"pgsql-novice@lists.postgresql.org" <pgsql-novice@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000efc885060afa852c"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwY9L7Dqvd9qqQCfyHF5o5As%2BskVEzsHf_2z_td9GG%3DNBA%40mail.gmail.com>
Precedence: bulk

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

On Saturday, November 25, 2023, Ibrahim Shaame <ishaame@gmail.com> wrote:

> Thank you Didier for the response. But I can't see the solution there you
> propose would give me the same thing (jina). Remember that the column
> "jina" was obtained as a result of displaying a family tree. Now what I
> would like is break out this column into a number of columns depending on
> the depth.
>
> Any suggestions?
>

Pull the data into your langauge of choice and build out the presentation
there.  SQL doesn=E2=80=99t do dynamic columns from data very well.

David J.

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

On Saturday, November 25, 2023, Ibrahim Shaame &lt;<a href=3D"mailto:ishaam=
e@gmail.com">ishaame@gmail.com</a>&gt; wrote:<br><blockquote class=3D"gmail=
_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:=
1ex"><div dir=3D"ltr"><div>Thank you Didier for the response. But I can&#39=
;t see the solution there you propose would give me the same thing (jina). =
Remember that the column &quot;jina&quot; was obtained as a result of displ=
aying a family tree. Now what I would like is break out this column into a =
number of columns depending on the depth.</div><div><br></div><div>Any sugg=
estions?</div></div></blockquote><div><br></div><div>Pull the data into you=
r langauge of choice and build out the presentation there.=C2=A0 SQL doesn=
=E2=80=99t do dynamic columns from data very well.</div><div><br></div><div=
>David J.</div><div><br></div><div>=C2=A0</div>

--000000000000efc885060afa852c--