Re: Convert pg_constraint.conkey array to same-order array of column names

On 3/24/23 9:44 AM, Dominique Devienne wrote:
> On Fri, Mar 24, 2023 at 5:40 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)com>> wrote:
>
> On 3/24/23 03:28, Dominique Devienne wrote:
> > On Thu, Mar 23, 2023 at 4:20 PM Adrian Klaver
> <adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
> > <mailto:adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)com>>> wrote:
> Your original question was:
>
> "But I'm wondering about getting 1 row per constraint instead,
> and fetching an array of column names.
>
> So is there a way to "convert" int2[] conkey array into a text[] of
> those
> column names?"
>
> That is what I showed as a simple example.
>
>
> Sorry, didn't mean to offend you.

There was no offense taken, it was about confusion as to what was being
asked?

>
> My post started with "preserving order of the columns",
> but I probably didn't make it clear enough preserving the source array's
> order was also a requirement.

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com