On Fri, Mar 24, 2023 at 11:51 AM Alvaro Herrera <alvhe...@alvh.no-ip.org> wrote:
> On 2023-Mar-23, Dominique Devienne wrote: > > But I'm wondering about getting 1 row per constraint instead, > > and fetching an array of column names. > > IIRC you can use array_agg(unnest ORDER BY ordinality), grouping by > constraint OID or name. > Thanks. This lead me to a better search, yielding two informative results: https://stackoverflow.com/questions/60877627/perform-unnest-inner-join-and-then-array-agg-as-part-of-an-update-query http://amyszczepanski.com/2019/03/25/unnest-and-array-agg-respecting-order.html
