| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Ibrahim Shaame <ishaame(at)gmail(dot)com> |
| Cc: | Didier Gasser-Morlay <didiergm(at)gmail(dot)com>, "pgsql-novice(at)lists(dot)postgresql(dot)org" <pgsql-novice(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: reporting tree into separate columns |
| Date: | 2023-11-25 14:02:44 |
| Message-ID: | CAKFQuwY9L7Dqvd9qqQCfyHF5o5As+skVEzsHf_2z_td9GG=NBA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Saturday, November 25, 2023, Ibrahim Shaame <ishaame(at)gmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomek | 2023-11-26 11:33:41 | Re: reporting tree into separate columns |
| Previous Message | Ibrahim Shaame | 2023-11-25 10:38:44 | Re: reporting tree into separate columns |