Re: Convert pg_constraint.conkey array to same-order array of column names
| От | Dominique Devienne |
|---|---|
| Тема | Re: Convert pg_constraint.conkey array to same-order array of column names |
| Дата | |
| Msg-id | CAFCRh-_zr5QFFjxXA5sPN90B9KKb6pjL6jwc2A+NtAH5jqRfaA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Convert pg_constraint.conkey array to same-order array of column names (Adrian Klaver <adrian.klaver@aklaver.com>) |
| Ответы |
Re: Convert pg_constraint.conkey array to same-order array of column names
|
| Список | pgsql-general |
On Fri, Mar 24, 2023 at 5:40 PM Adrian Klaver <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>> 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.
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.
В списке pgsql-general по дате отправления: