Re: reporting tree into separate columns - Mailing list pgsql-novice

From David G. Johnston
Subject Re: reporting tree into separate columns
Date
Msg-id CAKFQuwY9L7Dqvd9qqQCfyHF5o5As+skVEzsHf_2z_td9GG=NBA@mail.gmail.com
Whole thread Raw
In response to Re: reporting tree into separate columns  (Ibrahim Shaame <ishaame@gmail.com>)
List pgsql-novice
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’t do dynamic columns from data very well.

David J.

 

pgsql-novice by date:

Previous
From: Ibrahim Shaame
Date:
Subject: Re: reporting tree into separate columns
Next
From: Tomek
Date:
Subject: Re: reporting tree into separate columns