From: | Wim Bertels <wim(dot)bertels(at)ucll(dot)be> |
---|---|
To: | "shammat(at)gmx(dot)net" <shammat(at)gmx(dot)net>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: nested xml/json to table |
Date: | 2023-03-17 11:04:42 |
Message-ID: | 0d59af8d8b855c8f97796e611280b993ee261f7f.camel@ucll.be |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thomas Kellerer schreef op vr 17-03-2023 om 11:21 [+0100]:
> Wim Bertels schrieb am 17.03.2023 um 11:05:
> > what would be the general idea: "easily" convert an hierarchical
> > structure like json or xml to a table; for example creating columns
> > by
> > appending the key-names when going doing down the three, using null
> > for
> > empty values, adding more columns as needed by the given structure.
> > (1-way operation)
>
>
> You can't have a function that returns a different set of columns
> each time you call it
> (without specifying the output columns - which you don't want).
Hello Thomas,
thanks for the feedback,
i was wondering in the likes of existing built-in functions or
extensions (not CREATE FUNCTION)
mvg,
Wim
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Joseph Krogh | 2023-03-17 11:06:05 | Re: Delete values from JSON |
Previous Message | Romain MAZIÈRE | 2023-03-17 10:56:22 | Re: Delete values from JSON |