Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 3/24/23 9:44 AM, Dominique Devienne wrote:
On Fri, Mar 24, 2023 at 5:40 PM Adrian Klaver <adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>> wrote:

    On 3/24/23 03:28, Dominique Devienne wrote:
     > On Thu, Mar 23, 2023 at 4:20 PM Adrian Klaver
    <adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
     > <mailto:adrian.klaver@xxxxxxxxxxx
    <mailto:adrian.klaver@xxxxxxxxxxx>>> 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@xxxxxxxxxxx





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux