Re: Convert pg_constraint.conkey array to same-order array of column names - Mailing list pgsql-general

On 3/24/23 9:44 AM, Dominique Devienne wrote:
> On Fri, Mar 24, 2023 at 5:40 PM Adrian Klaver <adrian.klaver@aklaver.com 
> <mailto:adrian.klaver@aklaver.com>> wrote:
> 
>     On 3/24/23 03:28, Dominique Devienne wrote:
>      > On Thu, Mar 23, 2023 at 4:20 PM Adrian Klaver
>     <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>      > <mailto:adrian.klaver@aklaver.com
>     <mailto:adrian.klaver@aklaver.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.klaver@aklaver.com