Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pXq0l-0005ii-SK for pgsql-general@arkaria.postgresql.org; Thu, 02 Mar 2023 20:58:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pXq0k-0002zl-Ba for pgsql-general@arkaria.postgresql.org; Thu, 02 Mar 2023 20:58:46 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pXq0j-0002zb-VT for pgsql-general@lists.postgresql.org; Thu, 02 Mar 2023 20:58:46 +0000 Received: from mail-qt1-x836.google.com ([2607:f8b0:4864:20::836]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pXq0h-0005X4-Fj for pgsql-general@lists.postgresql.org; Thu, 02 Mar 2023 20:58:45 +0000 Received: by mail-qt1-x836.google.com with SMTP id d7so689018qtr.12 for ; Thu, 02 Mar 2023 12:58:43 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; t=1677790722; h=content-transfer-encoding:subject:from:content-language:to :user-agent:mime-version:date:message-id:from:to:cc:subject:date :message-id:reply-to; bh=WvFbn0dHCEZhAm420Nm6y1qfesA3hLcdmsnK0vJfGT0=; b=mGvvFtHmWq4GPV171XJaN3Ls9/esDheiHoyH4sf5QbAImi9Wy3RkyRsKZKjebp+mnH L6Xhv+RJPbvKICXmLtBoXL4BJLljdRfoBuXWKwXLopcLeIRP1UdGESNCdaqMCjAsDd8H 6OOB4bwPXiQZ0FzOGlqg3GNprnBnUVXXTtyjOrh18Sl3tZCXrsZXSLLnRHdqjyHJyUh/ rNvC3JF5pwGrshSQ1jytSojdt3+w5e7QbT9VvInFZQlPzq+1eidKvE1LUArh2LFpeayS t4UIND8lzdG+JU4EfWeIUzU7rhuyV9ZERU22GBEPMw1lQZemNzNPuN51gwqLGA4ehQGY 2zJg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; t=1677790722; h=content-transfer-encoding:subject:from:content-language:to :user-agent:mime-version:date:message-id:x-gm-message-state:from:to :cc:subject:date:message-id:reply-to; bh=WvFbn0dHCEZhAm420Nm6y1qfesA3hLcdmsnK0vJfGT0=; b=Lqilw/StpYX5SsrkbR6iwWGo6rcuBNmpTCrlBhjHE4Nt87XILQ7dUzvENrCW6lkQtP err6I7pci0DvE9kwzA+rXOkujp0VDexhcSCqSGK/WTiAnaJmM3WABn4dAw29JQ+SY8xM 1fse4Ps9x2pMnRgKdT4fsY4tM0GJWEEhatgOQbA+fU9amC2hdu202AwjCaUbnjks5Djb Yw1JLdcA5rxRd+jYHrHqyheTjI6mv7zgogaenBhH1koLcJ2D/f60DWpOGr4oM3GMRTYS A6TVK+qqUwKQJE1OkI/K7hWJMliivt9eyciIoCmhonpns3RGY86n92zZ3yID4r3smGk4 qPsA== X-Gm-Message-State: AO0yUKXeD19YT20/RGXHfgadHRnlQ73XkJI+hKHsZfJ5tabRMmnUJL7A QQ7iBTqC6jMOW+w1p6hhF2KUI61DZ0U= X-Google-Smtp-Source: AK7set/IGTY+Nm/G/MKQbvsZ1OUU9+lBTomPQbpQSMGp8ie88qntGRa5//zkfQSsJqXIaGfVrtgu8w== X-Received: by 2002:a05:622a:138f:b0:3bb:855a:9ed7 with SMTP id o15-20020a05622a138f00b003bb855a9ed7mr20100413qtk.42.1677790722013; Thu, 02 Mar 2023 12:58:42 -0800 (PST) Received: from ?IPV6:2600:1700:bd2c:b810::43? ([2600:1700:bd2c:b810::43]) by smtp.googlemail.com with ESMTPSA id t190-20020a3746c7000000b0074235745fdasm372368qka.58.2023.03.02.12.58.41 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 02 Mar 2023 12:58:41 -0800 (PST) Message-ID: <788ab733-d0d1-7791-fb22-7c2724b08816@gmail.com> Date: Thu, 2 Mar 2023 14:58:41 -0600 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.4.2 To: pgsql-general@lists.postgresql.org Content-Language: en-US From: Ron Subject: Converting row elements into a arrays? Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Postgresql 12.13 Given the sample below, I'm looking for how to generate this output.  It's like GROUP BY, but generating an array instead of an aggreate number.  f1 | f2_array ----+--------- 1 | {1,2,3}   2 | {1,2,3,4}   3 | {1,2} The ultimate goal is to somehow use pg_index.indkey to get column names from pg_attribute. create table foo (f1 int, f2 int); insert into foo values (1, 1); insert into foo values (1, 2); insert into foo values (1, 3); insert into foo values (2, 1); insert into foo values (2, 2); insert into foo values (2, 3); insert into foo values (2, 4); insert into foo values (3, 1); insert into foo values (3, 2); select * from foo order by f1, f2;  f1 | f2 ----+----   1 |  1   1 |  2   1 |  3   2 |  1   2 |  2   2 |  3   2 |  4   3 |  1   3 |  2 (9 rows) -- Born in Arizona, moved to Babylonia.