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  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список 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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Convert pg_constraint.conkey array to same-order array of column names
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Convert pg_constraint.conkey array to same-order array of column names